APPS.HR_PRE_PAY dependencies on PAY_ACTION_INTERLOCKS

Line 52: from pay_action_interlocks pai2,

48: select pet2.output_currency_code,
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

Line 1489: pay_action_interlocks pai,

1485: select paa_chd.assignment_action_id,
1486: paa_chd.run_type_id,
1487: prt.run_method,paa_chd.assignment_id
1488: from pay_assignment_actions paa_par,
1489: pay_action_interlocks pai,
1490: pay_assignment_actions paa_chd,
1491: pay_payroll_actions ppa_chd,
1492: pay_run_types_f prt
1493: where paa_par.assignment_action_id = p_assignment_action

Line 2047: pay_action_interlocks pai,

2043:
2044: cursor chdact is
2045: select paa_chd.assignment_action_id, paa_chd.run_type_id, prt.run_method,paa_chd.assignment_id
2046: from pay_assignment_actions paa_par,
2047: pay_action_interlocks pai,
2048: pay_assignment_actions paa_chd,
2049: pay_payroll_actions ppa_chd,
2050: pay_run_types_f prt
2051: where paa_par.assignment_action_id = p_assignment_action

Line 2768: pay_action_interlocks pai

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
2770: and pai.locked_action_id = paa.assignment_action_id
2771: and paa.assignment_action_id = prr.assignment_action_id
2772: and paa.payroll_action_id = ppa.payroll_action_id

Line 3015: from pay_action_interlocks pai,

3011: paa.assignment_id,
3012: paa_mas.payroll_action_id pre_payroll_action_id,
3013: paa.tax_unit_id run_tax_unit_id,
3014: paa_mas.chunk_number pre_chunk_number
3015: from pay_action_interlocks pai,
3016: pay_assignment_actions paa,
3017: pay_assignment_actions paa_mas
3018: where pai.locking_action_id = paa_mas.assignment_action_id
3019: and paa_mas.assignment_action_id = p_action

Line 3022: from pay_action_interlocks pai2,

3018: where pai.locking_action_id = paa_mas.assignment_action_id
3019: and paa_mas.assignment_action_id = p_action
3020: and pai.locked_action_id = paa.assignment_action_id
3021: and exists (select ''
3022: from pay_action_interlocks pai2,
3023: pay_assignment_actions paa2
3024: where pai2.locking_action_id = paa_mas.assignment_action_id
3025: and pai2.locked_action_id = paa2.assignment_action_id
3026: and paa2.tax_unit_id <> paa.tax_unit_id)

Line 3037: from pay_action_interlocks pai,

3033: paa.tax_unit_id run_tax_unit_id,
3034: paa_mas.chunk_number pre_chunk_number,
3035: paa.start_date start_date,
3036: paa.end_date end_date
3037: from pay_action_interlocks pai,
3038: pay_assignment_actions paa,
3039: pay_assignment_actions paa_mas
3040: where pai.locking_action_id = paa_mas.assignment_action_id
3041: and paa_mas.assignment_action_id = p_action

Line 3048: -- from pay_action_interlocks pai2,

3044: -- North America can only handle child actions on
3045: -- multiple assignment payrolls
3046: --
3047: --and exists (select ''
3048: -- from pay_action_interlocks pai2,
3049: -- pay_assignment_actions paa2
3050: -- where pai2.locking_action_id = paa_mas.assignment_action_id
3051: -- and pai2.locked_action_id = paa2.assignment_action_id
3052: -- and paa2.assignment_id <> paa.assignment_id)

Line 3441: pay_action_interlocks pai,

3437: from pay_payroll_actions ppa_pru,
3438: pay_payroll_actions ppa_pre,
3439: pay_assignment_actions paa_pru,
3440: pay_assignment_actions paa_pre,
3441: pay_action_interlocks pai,
3442: pay_pre_payments ppp
3443: where
3444: paa_pru.assignment_action_id = p_asg_act
3445: and ppa_pru.payroll_action_id = paa_pru.payroll_action_id