DBA Data[Home] [Help]

APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 989: ,pay_run_results prr

985: ,p_assig_action_id NUMBER)
986: IS
987: SELECT prrv.result_value reference
988: FROM pay_element_entries_f peef
989: ,pay_run_results prr
990: ,pay_run_result_values prrv
991: ,pay_input_values_f piv
992: WHERE peef.element_entry_id = p_element_entry_id
993: and piv.name ='Reference'

Line 1252: pay_run_results prr

1248: p_element_type_id NUMBER,
1249: p_input_value_id NUMBER) IS
1250: SELECT prv.result_value
1251: FROM pay_run_result_values prv,
1252: pay_run_results prr
1253: WHERE prr.status IN ('P','PA')
1254: AND prv.run_result_id = prr.run_result_id
1255: AND prr.assignment_action_id = p_assignment_action_id
1256: AND prr.element_type_id = p_element_type_id