APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_RUN_RESULT_VALUES

Line 1254: FROM pay_run_result_values prrv

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

Line 1283: ,pay_run_result_values TARGET

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

Line 2001: ,pay_run_result_values process

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
2004: where BAL_ASSACT.assignment_action_id = p_assignment_action_id
2005: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id

Line 2002: ,pay_run_result_values TARGET

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
2004: where BAL_ASSACT.assignment_action_id = p_assignment_action_id
2005: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
2006: and FEED.balance_type_id = p_bal_type_id + DECODE(TARGET.input_value_id,null,0,0)

Line 2037: ,pay_run_result_values process

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

Line 2038: ,pay_run_result_values TARGET

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

Line 2069: pay_run_result_values process

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
2071: and prr.run_result_id = process.run_result_id
2072: and prr.element_type_id = pet.element_type_id
2073: and pet.element_type_id = process_iv.element_type_id