DBA Data[Home] [Help]

APPS.PAYWSFGT_PKG dependencies on PAY_FUNCTIONAL_USAGES

Line 79: FROM pay_functional_usages pfu,

75: cp_id IN NUMBER,
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

Line 92: FROM pay_functional_usages pfu,

88: cp_id IN NUMBER,
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

Line 105: FROM pay_functional_usages pfu,

101: cp_id IN NUMBER,
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