DBA Data[Home] [Help]

APPS.PAYWSFGT_PKG dependencies on PAY_FUNCTIONAL_AREAS

Line 80: pay_functional_areas pfa,

76: cp_leg IN VARCHAR2
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

Line 93: pay_functional_areas pfa,

89: cp_bus IN NUMBER
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

Line 106: pay_functional_areas pfa,

102: cp_pay IN VARCHAR2
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