APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_RUN_RESULT_VALUES

Line 1275: FROM pay_run_result_values prrv

1271: IS
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

Line 1304: ,pay_run_result_values TARGET

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
1308: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id

Line 2030: ,pay_run_result_values process

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
2032: ,pay_balance_feeds_f FEED
2033: where BAL_ASSACT.assignment_action_id = p_assignment_action_id
2034: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id

Line 2031: ,pay_run_result_values TARGET

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
2032: ,pay_balance_feeds_f FEED
2033: where BAL_ASSACT.assignment_action_id = p_assignment_action_id
2034: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
2035: and FEED.balance_type_id = p_bal_type_id + DECODE(TARGET.input_value_id,null,0,0)

Line 2071: ,pay_run_result_values process

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
2074: where FEED.balance_type_id = p_bal_type_id + DECODE(TARGET.input_value_id,null,0,0)
2075: and FEED.input_value_id = TARGET.input_value_id

Line 2072: ,pay_run_result_values TARGET

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
2074: where FEED.balance_type_id = p_bal_type_id + DECODE(TARGET.input_value_id,null,0,0)
2075: and FEED.input_value_id = TARGET.input_value_id
2076: and nvl(TARGET.result_value,'0') <> '0'

Line 2103: pay_run_result_values process

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
2105: and prr.run_result_id = process.run_result_id
2106: and prr.element_type_id = pet.element_type_id
2107: and pet.element_type_id = process_iv.element_type_id