APPS.PAY_ES_ADVANCE_PAY dependencies on PAY_ADVANCE_PAY_ELE_PKG

Line 38: IF ( (pay_advance_pay_ele_pkg.g_adv_pay_process = 'W' AND

34: END IF;
35: OPEN csr_creator_type(l_effective_date);
36: FETCH csr_creator_type INTO l_creator_type;
37: CLOSE csr_creator_type;
38: IF ( (pay_advance_pay_ele_pkg.g_adv_pay_process = 'W' AND
39: l_creator_type = 'AD') OR
40: ( (pay_advance_pay_ele_pkg.g_adv_pay_process <> 'W' OR
41: pay_advance_pay_ele_pkg.g_adv_pay_process IS NULL) AND
42: (l_creator_type NOT IN ('AD', 'AE') )

Line 40: ( (pay_advance_pay_ele_pkg.g_adv_pay_process <> 'W' OR

36: FETCH csr_creator_type INTO l_creator_type;
37: CLOSE csr_creator_type;
38: IF ( (pay_advance_pay_ele_pkg.g_adv_pay_process = 'W' AND
39: l_creator_type = 'AD') OR
40: ( (pay_advance_pay_ele_pkg.g_adv_pay_process <> 'W' OR
41: pay_advance_pay_ele_pkg.g_adv_pay_process IS NULL) AND
42: (l_creator_type NOT IN ('AD', 'AE') )
43: )
44: )

Line 41: pay_advance_pay_ele_pkg.g_adv_pay_process IS NULL) AND

37: CLOSE csr_creator_type;
38: IF ( (pay_advance_pay_ele_pkg.g_adv_pay_process = 'W' AND
39: l_creator_type = 'AD') OR
40: ( (pay_advance_pay_ele_pkg.g_adv_pay_process <> 'W' OR
41: pay_advance_pay_ele_pkg.g_adv_pay_process IS NULL) AND
42: (l_creator_type NOT IN ('AD', 'AE') )
43: )
44: )
45: THEN