DBA Data[Home] [Help]

APPS.PAY_AU_RECON_SUMMARY dependencies on PAY_ELEMENT_TYPES_F

Line 182: FROM pay_element_types_f pet

178: null,null,null,null) balance_value
179: from
180: ( SELECT DISTINCT NVL(pbt.reporting_name,pbt.balance_name) balance_name,
181: pdb.defined_balance_id def_id
182: FROM pay_element_types_f pet
183: ,per_all_assignments_f paa
184: ,pay_balance_types pbt
185: ,pay_defined_balances pdb
186: ,pay_balance_dimensions pbd

Line 232: ,pay_element_types_f pet

228: FROM per_all_assignments_f paf
229: ,pay_payroll_actions ppa
230: ,pay_assignment_actions paa
231: ,pay_run_results prr
232: ,pay_element_types_f pet
233: WHERE paa.assignment_id = c_assignment_id
234: AND paf.business_group_id = ppa.business_group_id
235: AND ppa.effective_date BETWEEN c_start_date AND c_end_date
236: AND ppa.action_type in ('R','Q','B','V','I')