APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_RUN_RESULTS

Line 1255: ,pay_run_results prr

1251: SELECT to_number(prrv.result_value) result
1252: ,prr.start_date
1253: ,prr.end_date
1254: FROM pay_run_result_values prrv
1255: ,pay_run_results prr
1256: WHERE prrv.run_result_id = prr.run_result_id
1257: AND prr.assignment_action_id = p_asg_act_id
1258: AND prr.start_date >= p_start_date
1259: AND prr.end_date <= p_end_date

Line 1282: ,pay_run_results RR

1278: FROM pay_assignment_actions BAL_ASSACT
1279: ,pay_payroll_actions BACT
1280: ,pay_assignment_actions ASSACT
1281: ,pay_payroll_actions PACT
1282: ,pay_run_results RR
1283: ,pay_run_result_values TARGET
1284: ,pay_balance_feeds_f FEED
1285: ,per_time_periods PTP
1286: WHERE BAL_ASSACT.assignment_action_id = p_asg_act_id

Line 1999: ,pay_run_results RR

1995: FROM pay_assignment_actions BAL_ASSACT
1996: ,pay_payroll_actions BACT
1997: ,pay_assignment_actions ASSACT
1998: ,pay_payroll_actions PACT
1999: ,pay_run_results RR
2000: ,pay_input_values_f process_iv
2001: ,pay_run_result_values process
2002: ,pay_run_result_values TARGET
2003: ,pay_balance_feeds_f FEED

Line 2035: ,pay_run_results RR

2031: SELECT /*+ ORDERED */nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
2032: /* Assignment with Date worked for Run */
2033: FROM pay_assignment_actions ASSACT
2034: ,pay_payroll_actions PACT
2035: ,pay_run_results RR
2036: ,pay_input_values_f process_iv
2037: ,pay_run_result_values process
2038: ,pay_run_result_values TARGET
2039: ,pay_balance_feeds_f FEED

Line 2066: FROM pay_run_results prr,

2062: p_start_date DATE,
2063: p_end_date DATE
2064: ) IS
2065: SELECT /*+ ORDERED */ 'N'
2066: FROM pay_run_results prr,
2067: pay_element_types_f pet,
2068: pay_input_values_f process_iv,
2069: pay_run_result_values process
2070: WHERE prr.run_result_id = p_run_result_id