APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 1056: ,pay_run_results prr

1052: ,p_assig_action_id NUMBER)
1053: IS
1054: SELECT prrv.result_value reference
1055: FROM pay_element_entries_f peef
1056: ,pay_run_results prr
1057: ,pay_run_result_values prrv
1058: ,pay_input_values_f piv
1059: WHERE peef.element_entry_id = p_element_entry_id
1060: and piv.name ='Reference'

Line 1318: pay_run_results prr

1314: p_element_type_id NUMBER,
1315: p_input_value_id NUMBER) IS
1316: SELECT prv.result_value
1317: FROM pay_run_result_values prv,
1318: pay_run_results prr
1319: WHERE prr.status IN ('P','PA')
1320: AND prv.run_result_id = prr.run_result_id
1321: AND prr.assignment_action_id = p_assignment_action_id
1322: AND prr.element_type_id = p_element_type_id

Line 2685: pay_run_results prr, -- run result created by the payroll run/quick pay

2681: pay_assignment_actions paa, -- payroll run/quickpay action
2682: pay_payroll_actions ppa1, -- payroll run/quickpay action
2683: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
2684: pay_input_values_f piv, -- "Pay values" of type Money
2685: pay_run_results prr, -- run result created by the payroll run/quick pay
2686: pay_run_result_values prv -- Run Result value (Pay Value) created by the payroll run/quickpay
2687: WHERE lck.locking_action_id = paa2.assignment_action_id
2688: AND paa2.payroll_action_id = pai.action_context_id
2689: AND pai.action_context_type = 'PA'