DBA Data[Home] [Help]

APPS.PAY_KW_ANNUAL_REPORTS dependencies on PAY_ELEMENT_ENTRIES_F

Line 1449: pay_element_entries_f pee,

1445: SELECT rrv.RESULT_VALUE val,pee.entry_information1 ref,pee.entry_information2 authority,pee.entry_information3 type,
1446: pee.entry_information4 debt,fnd_date.canonical_to_date(pee.entry_information5) start_d
1447: ,fnd_date.canonical_to_date(pee.entry_information6) end_d ,pet.element_type_id
1448: FROM pay_element_types_f pet,
1449: pay_element_entries_f pee,
1450: pay_run_results prr,
1451: pay_run_result_values rrv,
1452: pay_input_values_f piv
1453: WHERE rrv.RUN_RESULT_ID = prr.RUN_RESULT_ID

Line 1472: pay_element_entries_f pee,

1468: select distinct eev1.SCREEN_ENTRY_VALUE val, eev2.SCREEN_ENTRY_VALUE ref, eev3.SCREEN_ENTRY_VALUE authority, '72' type,
1469: eev4.SCREEN_ENTRY_VALUE debt,eev1.effective_start_date start_d,eev1.effective_end_date end_d, pet.element_type_id
1470: from pay_element_entry_values_f eev1,
1471: pay_element_types_f pet,
1472: pay_element_entries_f pee,
1473: pay_input_values_f piv1,
1474: pay_input_values_f piv2,
1475: pay_input_values_f piv3,
1476: pay_input_values_f piv4,