DBA Data[Home] [Help]

APPS.PAY_KW_ANNUAL_REPORTS dependencies on PAY_ELEMENT_TYPES_F

Line 1506: FROM pay_element_types_f pet,

1502: CURSOR csr_get_ded_details (l_assignment_id number , l_assignment_action_id number, l_effective_date date) IS
1503: SELECT rrv.RESULT_VALUE val,pee.entry_information1 ref,pee.entry_information2 authority,pee.entry_information3 type,
1504: pee.entry_information4 debt,fnd_date.canonical_to_date(pee.entry_information5) start_d
1505: ,fnd_date.canonical_to_date(pee.entry_information6) end_d ,pet.element_type_id
1506: FROM pay_element_types_f pet,
1507: pay_element_entries_f pee,
1508: pay_run_results prr,
1509: pay_run_result_values rrv,
1510: pay_input_values_f piv

Line 1529: pay_element_types_f pet,

1525: UNION
1526: select distinct eev1.SCREEN_ENTRY_VALUE val, eev2.SCREEN_ENTRY_VALUE ref, eev3.SCREEN_ENTRY_VALUE authority, '72' type,
1527: eev4.SCREEN_ENTRY_VALUE debt,eev1.effective_start_date start_d,eev1.effective_end_date end_d, pet.element_type_id
1528: from pay_element_entry_values_f eev1,
1529: pay_element_types_f pet,
1530: pay_element_entries_f pee,
1531: pay_input_values_f piv1,
1532: pay_input_values_f piv2,
1533: pay_input_values_f piv3,