APPS.PQP_GB_PSI_FUNCTIONS dependencies on PAY_RUN_RESULT_VALUES

Line 1002: FROM pay_run_result_values prrv

998: )
999: IS
1000: SELECT to_number(prrv.result_value) result,
1001: prrv.run_result_id -- to be used as ee.source_id for retro elements
1002: FROM pay_run_result_values prrv
1003: ,pay_run_results prr
1004: WHERE prrv.run_result_id = prr.run_result_id
1005: AND prr.assignment_action_id = p_asg_act_id
1006: -- AND prr.element_type_id = p_element_type_id

Line 1028: INDEX (RRV PAY_RUN_RESULT_VALUES_N50)

1024: INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N1 )
1025: INDEX (PACT PAY_PAYROLL_ACTIONS_PK)
1026: INDEX (EE PAY_ELEMENT_ENTRIES_F_N50)
1027: INDEX (RR PAY_RUN_RESULTS_N51)
1028: INDEX (RRV PAY_RUN_RESULT_VALUES_N50)
1029: */
1030: RRV.input_value_id,
1031: RRV.result_value,
1032: BACT.effective_date,

Line 1047: pay_run_result_values RRV

1043: pay_assignment_actions ASSACT,
1044: pay_payroll_actions PACT,
1045: pay_element_entries_f EE,
1046: pay_run_results RR,
1047: pay_run_result_values RRV
1048: where BAL_ASSACT.assignment_action_id = p_assignment_action_id
1049: and BACT.payroll_action_id = BAL_ASSACT.payroll_action_id
1050: and BACT.action_type <> 'V'
1051: and ASSACT.assignment_id = BAL_ASSACT.assignment_id