APPS.HR_PRE_PAY dependencies on PAY_RUN_RESULTS

Line 53: pay_run_results prr2,

49: pet2.element_type_id,
50: prr2.run_result_id,
51: paa.assignment_id
52: from pay_action_interlocks pai2,
53: pay_run_results prr2,
54: pay_element_types_f pet2,
55: pay_payroll_actions ppa,
56: pay_assignment_actions paa
57: where pai2.locking_action_id = p_assignment_action

Line 2302: pay_run_results prr2,

2298: from
2299: pay_input_values_f piv,
2300: pay_element_types_f pet,
2301: pay_run_result_values rrv,
2302: pay_run_results prr2,
2303: pay_run_results prr,
2304: pay_assignment_actions paa,
2305: pay_payroll_actions ppa
2306: where prr.run_result_id = p_run_result

Line 2303: pay_run_results prr,

2299: pay_input_values_f piv,
2300: pay_element_types_f pet,
2301: pay_run_result_values rrv,
2302: pay_run_results prr2,
2303: pay_run_results prr,
2304: pay_assignment_actions paa,
2305: pay_payroll_actions ppa
2306: where prr.run_result_id = p_run_result
2307: and paa.assignment_action_id= prr.assignment_action_id

Line 2348: pay_run_results prr2,

2344: from
2345: pay_input_values_f piv,
2346: pay_element_types_f pet,
2347: pay_run_result_values rrv,
2348: pay_run_results prr2,
2349: pay_run_results prr
2350: where prr.run_result_id = p_run_result
2351: and prr.assignment_action_id = assign_action_id
2352: and pet.element_type_id = prr2.element_type_id

Line 2349: pay_run_results prr

2345: pay_input_values_f piv,
2346: pay_element_types_f pet,
2347: pay_run_result_values rrv,
2348: pay_run_results prr2,
2349: pay_run_results prr
2350: where prr.run_result_id = p_run_result
2351: and prr.assignment_action_id = assign_action_id
2352: and pet.element_type_id = prr2.element_type_id
2353: and pet.THIRD_PARTY_PAY_ONLY_FLAG = 'Y'

Line 2375: pay_run_results prr2,

2371: pay_element_entries_f pee,
2372: pay_input_values_f piv,
2373: pay_element_types_f pet,
2374: pay_run_result_values rrv,
2375: pay_run_results prr2,
2376: pay_run_results prr
2377: where pee.target_entry_id=entry
2378: and pee.assignment_id = assign_id
2379: and prr.source_id=pee.element_entry_id

Line 2376: pay_run_results prr

2372: pay_input_values_f piv,
2373: pay_element_types_f pet,
2374: pay_run_result_values rrv,
2375: pay_run_results prr2,
2376: pay_run_results prr
2377: where pee.target_entry_id=entry
2378: and pee.assignment_id = assign_id
2379: and prr.source_id=pee.element_entry_id
2380: and prr.assignment_action_id = assign_action_id

Line 2446: from pay_run_results prr,

2442: /*Here calculating the max effective end date of the element entry for a particular run result*/
2443:
2444: select max(pee.effective_end_date)
2445: into l_max_eff_end_date
2446: from pay_run_results prr,
2447: pay_element_entries_f pee
2448: where prr.run_result_id = p_run_results
2449: and prr.source_id = pee.element_entry_id ;
2450:

Line 2468: from pay_run_results prr,

2464: ppt.pre_validation_required validation_required,
2465: ppt.validation_value validation_value,
2466: ppm.external_account_id external_account_id
2467: into payment_details
2468: from pay_run_results prr,
2469: pay_element_entries_f pee,
2470: pay_personal_payment_methods_f ppm,
2471: pay_external_accounts pea,
2472: pay_org_payment_methods_f opm,

Line 2546: pay_run_results prr,

2542: into rt_method,
2543: sep_chq_aa_id
2544: from pay_run_types_f prt,
2545: pay_assignment_actions paa,
2546: pay_run_results prr,
2547: pay_payroll_actions ppa
2548: where prr.run_result_id = p_run_results
2549: and prr.assignment_action_id = paa.assignment_action_id
2550: and paa.payroll_action_id = ppa.payroll_action_id

Line 2765: pay_run_results prr,

2761: is
2762: select distinct (prrv.result_value) organization_id
2763: from pay_run_result_values prrv,
2764: pay_input_values_f piv,
2765: pay_run_results prr,
2766: pay_assignment_actions paa,
2767: pay_payroll_actions ppa,
2768: pay_action_interlocks pai
2769: where pai.locking_action_id = p_asg_action