APPS.PAY_KW_PIFSS_REPORT dependencies on PAY_ELEMENT_TYPES_F

Line 415: FROM pay_element_types_f pet,

411:
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

Line 436: from pay_element_types_f pet,

432: AND TRUNC(l_effective_date,'MM') between trunc(pet.effective_start_date,'MM') and nvl(pet.effective_end_date,to_date('31-12-4712','DD-MM-YYYY'));
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')