APPS.PAY_GB_COURT_ORDER_UPGRADE dependencies on PAY_RUN_RESULTS

Line 50: SELECT distinct /*+ INDEX(prr PAY_RUN_RESULTS_N50,PAY_RUN_RESULTS_N1) */

46: PROCEDURE upgrade_action_contexts(p_business_group_id number) IS
47: --
48: --
49: CURSOR csr_results (l_context_id NUMBER) IS
50: SELECT distinct /*+ INDEX(prr PAY_RUN_RESULTS_N50,PAY_RUN_RESULTS_N1) */
51: et.element_type_id
52: ,et.element_name
53: ,iv.input_value_id
54: ,iv.name input_value_name

Line 61: ,pay_run_results rr

57: ,aa.assignment_id
58: ,nvl(prrv.result_value,'Unknown') result_value
59: FROM pay_element_types_f et
60: ,pay_input_values_f iv
61: ,pay_run_results rr
62: ,per_assignments_f paf
63: ,pay_assignment_actions aa
64: ,pay_run_result_values prrv
65: WHERE paf.business_group_id = p_business_group_id

Line 259: pay_run_results prr,

255: pay_action_contexts pac,
256: ff_contexts fc,
257: pay_element_types_f pet,
258: pay_input_values_f piv,
259: pay_run_results prr,
260: pay_run_result_values prrv
261: ,pay_input_values_f piv1
262: ,pay_run_results prr1
263: ,pay_run_result_values prrv1

Line 262: ,pay_run_results prr1

258: pay_input_values_f piv,
259: pay_run_results prr,
260: pay_run_result_values prrv
261: ,pay_input_values_f piv1
262: ,pay_run_results prr1
263: ,pay_run_result_values prrv1
264: WHERE paf.assignment_id = paa.assignment_id
265: AND paf.person_id = p_person_id
266: AND fc.context_id = pac.context_id

Line 298: pay_run_results prr,

294: nvl((prrv.result_value - p_paid_value),'0') overpaid
295: FROM
296: pay_element_types_f pet,
297: pay_input_values_f piv,
298: pay_run_results prr,
299: pay_run_result_values prrv,
300: pay_input_values_f piv1,
301: pay_run_results prr1,
302: pay_run_result_values prrv1

Line 301: pay_run_results prr1,

297: pay_input_values_f piv,
298: pay_run_results prr,
299: pay_run_result_values prrv,
300: pay_input_values_f piv1,
301: pay_run_results prr1,
302: pay_run_result_values prrv1
303: WHERE pet.element_name IN ('Court Order','Court Order NTPP')
304: AND pet.legislation_code = 'GB'
305: AND piv.element_type_id = pet.element_type_id