APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_RUN_RESULTS

Line 1276: ,pay_run_results prr

1272: SELECT to_number(prrv.result_value) result
1273: ,prr.start_date
1274: ,prr.end_date
1275: FROM pay_run_result_values prrv
1276: ,pay_run_results prr
1277: WHERE prrv.run_result_id = prr.run_result_id
1278: AND prr.assignment_action_id = p_asg_act_id
1279: AND prr.start_date >= p_start_date
1280: AND prr.end_date <= p_end_date

Line 1303: ,pay_run_results RR

1299: FROM pay_assignment_actions BAL_ASSACT
1300: ,pay_payroll_actions BACT
1301: ,pay_assignment_actions ASSACT
1302: ,pay_payroll_actions PACT
1303: ,pay_run_results RR
1304: ,pay_run_result_values TARGET
1305: ,pay_balance_feeds_f FEED
1306: ,per_time_periods PTP
1307: WHERE BAL_ASSACT.assignment_action_id = p_asg_act_id

Line 2027: ,pay_run_results RR

2023: FROM pay_assignment_actions BAL_ASSACT
2024: ,pay_payroll_actions BACT
2025: ,pay_assignment_actions ASSACT
2026: ,pay_payroll_actions PACT
2027: ,pay_run_results RR
2028: ,pay_element_types_f pet
2029: ,pay_input_values_f process_iv
2030: ,pay_run_result_values process
2031: ,pay_run_result_values TARGET

Line 2069: ,pay_run_results RR

2065: SELECT /*+ ORDERED */nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
2066: /* Assignment with Date worked for Run */
2067: FROM pay_assignment_actions ASSACT
2068: ,pay_payroll_actions PACT
2069: ,pay_run_results RR
2070: ,pay_input_values_f process_iv
2071: ,pay_run_result_values process
2072: ,pay_run_result_values TARGET
2073: ,pay_balance_feeds_f FEED

Line 2100: FROM pay_run_results prr,

2096: p_start_date DATE,
2097: p_end_date DATE
2098: ) IS
2099: SELECT /*+ ORDERED */ 'N'
2100: FROM pay_run_results prr,
2101: pay_element_types_f pet,
2102: pay_input_values_f process_iv,
2103: pay_run_result_values process
2104: WHERE prr.run_result_id = p_run_result_id