APPS.PAY_IE_ADVANCE_PAY dependencies on PAY_ADVANCE_PAY_ELE_PKG

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

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') )

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

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: )

Line 47: pay_advance_pay_ele_pkg.g_adv_pay_process IS NULL) AND

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