APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 990: ,pay_run_result_values prrv

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'
994: and piv.legislation_code='GB'

Line 1251: FROM pay_run_result_values prv,

1247: CURSOR csr_element_values (p_assignment_action_id NUMBER,
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

Line 1267: l_result_value pay_run_result_values.result_value%TYPE;

1263: l_main_sequence NUMBER;
1264: l_multi_sequence NUMBER;
1265: l_ovn NUMBER;
1266: l_record_count VARCHAR2(10);
1267: l_result_value pay_run_result_values.result_value%TYPE;
1268:
1269: BEGIN
1270:
1271: hr_utility.set_location('Entering get_element_info',10);