You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
|
|
��U S E [ F a s t M o n e y P r o _ R e m i t ]
G O
/ * * * * * * O b j e c t : S t o r e d P r o c e d u r e [ d b o ] . [ p r o c _ G e t I n f o r m a t i o n F o r P a r t n e r s ] S c r i p t D a t e : 9 / 2 7 / 2 0 1 9 1 : 3 0 : 1 4 P M * * * * * * /
S E T A N S I _ N U L L S O N
G O
S E T Q U O T E D _ I D E N T I F I E R O N
G O
C R E A T E P R O C E D U R E [ d b o ] . [ p r o c _ G e t I n f o r m a t i o n F o r P a r t n e r s ]
@ f l a g v a r c h a r ( 3 0 ) = N U L L ,
@ e m a i l v a r c h a r ( 3 0 ) = N U L L ,
@ c i d i n t = N U L L
A S
I F @ f l a g = ' c o u n t r y c o d e '
B E G I N
S E L E C T c m . c o u n t r y C o d e
F R O M c o u n t r y M a s t e r c m ( N O L O C K )
W H E R E c m . c o u n t r y I d = @ c i d
E N D
E L S E I F @ f l a g = ' c r e a t e d d a t e '
B E G I N
S E L E C T c m . c r e a t e d D a t e
F R O M c u s t o m e r M a s t e r ( N O L O C K ) c m
W H E R E c m . e m a i l = @ e m a i l
E N D
G O
|
