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 2297: pay_run_results prr2,

2293: from
2294: pay_input_values_f piv,
2295: pay_element_types_f pet,
2296: pay_run_result_values rrv,
2297: pay_run_results prr2,
2298: pay_run_results prr,
2299: pay_assignment_actions paa,
2300: pay_payroll_actions ppa
2301: where prr.run_result_id = p_run_result

Line 2298: pay_run_results prr,

2294: pay_input_values_f piv,
2295: pay_element_types_f pet,
2296: pay_run_result_values rrv,
2297: pay_run_results prr2,
2298: pay_run_results prr,
2299: pay_assignment_actions paa,
2300: pay_payroll_actions ppa
2301: where prr.run_result_id = p_run_result
2302: and paa.assignment_action_id= prr.assignment_action_id

Line 2339: pay_run_results prr2,

2335: from
2336: pay_input_values_f piv,
2337: pay_element_types_f pet,
2338: pay_run_result_values rrv,
2339: pay_run_results prr2,
2340: pay_run_results prr
2341: where prr.run_result_id = p_run_result
2342: and prr.assignment_action_id = assign_action_id
2343: and pet.element_type_id = prr2.element_type_id

Line 2340: pay_run_results prr

2336: pay_input_values_f piv,
2337: pay_element_types_f pet,
2338: pay_run_result_values rrv,
2339: pay_run_results prr2,
2340: pay_run_results prr
2341: where prr.run_result_id = p_run_result
2342: and prr.assignment_action_id = assign_action_id
2343: and pet.element_type_id = prr2.element_type_id
2344: and pet.THIRD_PARTY_PAY_ONLY_FLAG = 'Y'

Line 2366: pay_run_results prr2,

2362: pay_element_entries_f pee,
2363: pay_input_values_f piv,
2364: pay_element_types_f pet,
2365: pay_run_result_values rrv,
2366: pay_run_results prr2,
2367: pay_run_results prr
2368: where pee.target_entry_id=entry
2369: and pee.assignment_id = assign_id
2370: and prr.source_id=pee.element_entry_id

Line 2367: pay_run_results prr

2363: pay_input_values_f piv,
2364: pay_element_types_f pet,
2365: pay_run_result_values rrv,
2366: pay_run_results prr2,
2367: pay_run_results prr
2368: where pee.target_entry_id=entry
2369: and pee.assignment_id = assign_id
2370: and prr.source_id=pee.element_entry_id
2371: and prr.assignment_action_id = assign_action_id

Line 2443: from pay_run_results prr,

2439: ppt.pre_validation_required validation_required,
2440: ppt.validation_value validation_value,
2441: ppm.external_account_id external_account_id
2442: into payment_details
2443: from pay_run_results prr,
2444: pay_element_entries_f pee,
2445: pay_personal_payment_methods_f ppm,
2446: pay_external_accounts pea,
2447: pay_org_payment_methods_f opm,

Line 2510: pay_run_results prr,

2506: into rt_method,
2507: sep_chq_aa_id
2508: from pay_run_types_f prt,
2509: pay_assignment_actions paa,
2510: pay_run_results prr,
2511: pay_payroll_actions ppa
2512: where prr.run_result_id = p_run_results
2513: and prr.assignment_action_id = paa.assignment_action_id
2514: and paa.payroll_action_id = ppa.payroll_action_id

Line 2727: pay_run_results prr,

2723: index(piv pay_input_values_f_pk) */
2724: distinct (prrv.result_value) organization_id
2725: from pay_run_result_values prrv,
2726: pay_input_values_f piv,
2727: pay_run_results prr,
2728: pay_assignment_actions paa,
2729: pay_payroll_actions ppa,
2730: pay_action_interlocks pai
2731: where pai.locking_action_id = p_asg_action