APPS.PQP_GB_TP_CONTRIBUTION_REPORT dependencies on PAY_INPUT_VALUES_F

Line 67: pay_input_values_f pivf ,

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
71: AND PTP.PAYROLL_ID = ppa.payroll_id

Line 182: pay_input_values_f pivf ,

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
186: AND PTP.PAYROLL_ID = ppa.payroll_id

Line 376: FROM pay_input_values_f piv

372: ,length (name) - 2)
373: ,'Pension Tier'
374: ,piv.input_value_id
375: ,0)) tier
376: FROM pay_input_values_f piv
377: WHERE piv.element_type_id = p_element_type_id
378: AND piv.legislation_code = 'GB'
379: AND p_effective_date BETWEEN piv.effective_start_date
380: AND piv.effective_end_date