APPS.PAY_NO_ADVANCE_PAY dependencies on PAY_ADVANCE_PAY_ELE_PKG

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

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

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

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

Line 44: pay_advance_pay_ele_pkg.g_adv_pay_process IS NULL) AND

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