DBA Data[Home] [Help]

APPS.PAY_KW_PIFSS_REPORT dependencies on PAY_RUN_RESULTS

Line 417: pay_run_results prr,

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
421: AND prr.assignment_action_id = l_assignment_action_id