APPS.PQP_GB_PSI_FUNCTIONS dependencies on PAY_RUN_RESULT_VALUES

Line 1031: FROM pay_run_result_values prrv

1027: )
1028: IS
1029: SELECT to_number(prrv.result_value) result,
1030: prrv.run_result_id -- to be used as ee.source_id for retro elements
1031: FROM pay_run_result_values prrv
1032: ,pay_run_results prr
1033: WHERE prrv.run_result_id = prr.run_result_id
1034: AND prr.assignment_action_id = p_asg_act_id
1035: -- AND prr.element_type_id = p_element_type_id

Line 1057: INDEX (RRV PAY_RUN_RESULT_VALUES_N50)

1053: INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N1 )
1054: INDEX (PACT PAY_PAYROLL_ACTIONS_PK)
1055: INDEX (EE PAY_ELEMENT_ENTRIES_F_N50)
1056: INDEX (RR PAY_RUN_RESULTS_N51)
1057: INDEX (RRV PAY_RUN_RESULT_VALUES_N50)
1058: */
1059: RRV.input_value_id,
1060: RRV.result_value,
1061: BACT.effective_date,

Line 1076: pay_run_result_values RRV

1072: pay_assignment_actions ASSACT,
1073: pay_payroll_actions PACT,
1074: pay_element_entries_f EE,
1075: pay_run_results RR,
1076: pay_run_result_values RRV
1077: where BAL_ASSACT.assignment_action_id = p_assignment_action_id
1078: and BACT.payroll_action_id = BAL_ASSACT.payroll_action_id
1079: and BACT.action_type <> 'V'
1080: and ASSACT.assignment_id = BAL_ASSACT.assignment_id