APPS.PAYWSFGT_PKG dependencies on PAY_FUNCTIONAL_TRIGGERS

Line 71: FROM pay_functional_triggers

67: ) RETURN BOOLEAN IS
68: --
69: CURSOR csr_in_area(cp_id IN NUMBER) IS
70: SELECT 'Y'
71: FROM pay_functional_triggers
72: WHERE event_id = cp_id;
73: --
74: CURSOR csr_leg_enb(
75: cp_id IN NUMBER,

Line 81: pay_functional_triggers pft

77: ) IS
78: SELECT 'Y'
79: FROM pay_functional_usages pfu,
80: pay_functional_areas pfa,
81: pay_functional_triggers pft
82: WHERE pfu.legislation_code IN (cp_leg,'-1')
83: AND pfu.area_id = pfa.area_id
84: AND pfa.area_id = pft.area_id
85: AND pft.event_id = cp_id;

Line 94: pay_functional_triggers pft

90: ) IS
91: SELECT 'Y'
92: FROM pay_functional_usages pfu,
93: pay_functional_areas pfa,
94: pay_functional_triggers pft
95: WHERE pfu.business_group_id IN (cp_bus,-1)
96: AND pfu.area_id = pfa.area_id
97: AND pfa.area_id = pft.area_id
98: AND pft.event_id = cp_id;

Line 107: pay_functional_triggers pft

103: ) IS
104: SELECT 'Y'
105: FROM pay_functional_usages pfu,
106: pay_functional_areas pfa,
107: pay_functional_triggers pft
108: WHERE pfu.payroll_id IN (cp_pay,-1)
109: AND pfu.area_id = pfa.area_id
110: AND pfa.area_id = pft.area_id
111: AND pft.event_id = cp_id;