APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 1057: ,pay_run_result_values prrv

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

Line 1317: FROM pay_run_result_values prv,

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

Line 1333: l_result_value pay_run_result_values.result_value%TYPE;

1329: l_main_sequence NUMBER;
1330: l_multi_sequence NUMBER;
1331: l_ovn NUMBER;
1332: l_record_count VARCHAR2(10);
1333: l_result_value pay_run_result_values.result_value%TYPE;
1334:
1335: BEGIN
1336:
1337: hr_utility.set_location('Entering get_element_info',10);

Line 2686: pay_run_result_values prv -- Run Result value (Pay Value) created by the payroll run/quickpay

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'
2690: AND pai.action_information_category = 'EMEA ELEMENT DEFINITION'