APPS.PQP_GB_TP_CONTRIBUTION_REPORT dependencies on PAY_RUN_RESULT_VALUES

Line 66: pay_run_result_values prrv ,

62: MAX(NVL(DECODE(PIVF.NAME,'Pension Tier C',prrv.result_value),0)) Pension_Tier_C
63: FROM pay_payroll_actions ppa ,
64: pay_assignment_actions paa ,
65: pay_run_results prr ,
66: pay_run_result_values prrv ,
67: pay_input_values_f pivf ,
68: PER_TIME_PERIODS PTP
69: WHERE ppa.business_group_id = p_business_group_id --Context
70: AND ppa.payroll_id = p_payroll_id --Context

Line 181: pay_run_result_values prrv ,

177: SUM(NVL(DECODE(PIVF.NAME,'Annual FTE Sal C',prrv.result_value),0)) Annual_FTE_Sal_C
178: FROM pay_payroll_actions ppa ,
179: pay_assignment_actions paa ,
180: pay_run_results prr ,
181: pay_run_result_values prrv ,
182: pay_input_values_f pivf ,
183: PER_TIME_PERIODS PTP
184: WHERE ppa.business_group_id = p_business_group_id --Context
185: AND ppa.payroll_id = p_payroll_id --Context

Line 455: ,pay_run_result_values prrv

451: ,0)) er
452: FROM pay_payroll_actions ppa
453: ,pay_assignment_actions paa
454: ,pay_run_results prr
455: ,pay_run_result_values prrv
456: WHERE ppa.business_group_id = p_business_group_id
457: AND ppa.payroll_id = p_payroll_id
458: AND ppa.action_status = 'C'
459: AND ppa.time_period_id = p_time_period_id

Line 500: ,pay_run_result_values prrv

496: ,p_input_values.er
497: ,prrv.result_value
498: ,0)) er
499: FROM pay_run_results prr
500: ,pay_run_result_values prrv
501: WHERE prr.assignment_action_id IN
502: (
503: SELECT paa.ASSIGNMENT_ACTION_ID
504: FROM pay_element_entries_f peef