40: OPEN csr_creator_type(l_effective_date);
41: FETCH csr_creator_type INTO l_creator_type;
42: CLOSE csr_creator_type;
43:
44: IF ( (pay_advance_pay_ele_pkg.g_adv_pay_process = 'W' AND
45: l_creator_type = 'AD') OR
46: ( (pay_advance_pay_ele_pkg.g_adv_pay_process <> 'W' OR
47: pay_advance_pay_ele_pkg.g_adv_pay_process IS NULL) AND
48: (l_creator_type NOT IN ('AD', 'AE') )
42: CLOSE csr_creator_type;
43:
44: IF ( (pay_advance_pay_ele_pkg.g_adv_pay_process = 'W' AND
45: l_creator_type = 'AD') OR
46: ( (pay_advance_pay_ele_pkg.g_adv_pay_process <> 'W' OR
47: pay_advance_pay_ele_pkg.g_adv_pay_process IS NULL) AND
48: (l_creator_type NOT IN ('AD', 'AE') )
49: )
50: )
43:
44: IF ( (pay_advance_pay_ele_pkg.g_adv_pay_process = 'W' AND
45: l_creator_type = 'AD') OR
46: ( (pay_advance_pay_ele_pkg.g_adv_pay_process <> 'W' OR
47: pay_advance_pay_ele_pkg.g_adv_pay_process IS NULL) AND
48: (l_creator_type NOT IN ('AD', 'AE') )
49: )
50: )
51: THEN