APPS.PAY_AU_RECON_SUMMARY dependencies on PAY_ELEMENT_ENTRIES_F

Line 235: PAY_ELEMENT_ENTRIES_F PEE ,

231: PAY_DEFINED_BALANCES PDB ,
232: PAY_BALANCE_DIMENSIONS PBD ,
233: PAY_BALANCE_FEEDS_F PBF ,
234: PAY_INPUT_VALUES_F PIV,
235: PAY_ELEMENT_ENTRIES_F PEE ,
236: PAY_ELEMENT_TYPES_F PET ,
237: PER_ALL_ASSIGNMENTS_F PAA ,
238: PER_PERIODS_OF_SERVICE PPS ,
239: PAY_RUN_RESULTS PRR ,

Line 277: Cursor Get_Retro_allowances(c_element_entry_id pay_element_entries_f.element_entry_id%type,

273: AND ppa.date_earned between piv.effective_start_date and piv.effective_end_date
274: ;
275:
276:
277: Cursor Get_Retro_allowances(c_element_entry_id pay_element_entries_f.element_entry_id%type,
278: c_balance_type_id pay_defined_balances.defined_balance_id%type)
279: IS
280: select NVL(pbt.reporting_name,pbt.balance_name) balance_name /* Bug 5743196 Added nvl */
281: ,prv.result_value balance_value

Line 283: pay_element_entries_f pee,

279: IS
280: select NVL(pbt.reporting_name,pbt.balance_name) balance_name /* Bug 5743196 Added nvl */
281: ,prv.result_value balance_value
282: from
283: pay_element_entries_f pee,
284: pay_run_results prr,
285: pay_run_result_values prv,
286: pay_element_types_f pet,
287: pay_balance_types pbt