DBA Data[Home] [Help]

APPS.PAY_KW_PIFSS_REPORT dependencies on PAY_ELEMENT_ENTRIES_F

Line 416: pay_element_entries_f pee,

412: CURSOR csr_get_ded_details (l_assignment_id number , l_assignment_action_id number, l_effective_date date) IS
413: SELECT rrv.RESULT_VALUE val,pee.entry_information3 type,fnd_date.canonical_to_date(pee.entry_information5) start_d
414: ,fnd_date.canonical_to_date(pee.entry_information6) end_d ,pet.element_type_id , pet.effective_start_date
415: FROM pay_element_types_f pet,
416: pay_element_entries_f pee,
417: pay_run_results prr,
418: pay_run_result_values rrv,
419: pay_input_values_f piv
420: WHERE rrv.RUN_RESULT_ID = prr.RUN_RESULT_ID

Line 437: pay_element_entries_f pee,

433:
434: CURSOR csr_get_install_number (l_assignment_id number , l_type_id number, l_start_date date) IS
435: select pev.screen_entry_value
436: from pay_element_types_f pet,
437: pay_element_entries_f pee,
438: pay_element_entry_values_f pev
439: where pet.element_type_id = l_type_id
440: AND trunc(pet.effective_start_date,'MM') = trunc(l_start_date,'MM')
441: AND pee.element_type_id = pet.element_type_id