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 1484: pay_action_interlocks pai,

1480: select paa_chd.assignment_action_id,
1481: paa_chd.run_type_id,
1482: prt.run_method,paa_chd.assignment_id
1483: from pay_assignment_actions paa_par,
1484: pay_action_interlocks pai,
1485: pay_assignment_actions paa_chd,
1486: pay_payroll_actions ppa_chd,
1487: pay_run_types_f prt
1488: where paa_par.assignment_action_id = p_assignment_action

Line 2042: pay_action_interlocks pai,

2038:
2039: cursor chdact is
2040: select paa_chd.assignment_action_id, paa_chd.run_type_id, prt.run_method,paa_chd.assignment_id
2041: from pay_assignment_actions paa_par,
2042: pay_action_interlocks pai,
2043: pay_assignment_actions paa_chd,
2044: pay_payroll_actions ppa_chd,
2045: pay_run_types_f prt
2046: where paa_par.assignment_action_id = p_assignment_action

Line 2730: pay_action_interlocks pai

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
2732: and pai.locked_action_id = paa.assignment_action_id
2733: and paa.assignment_action_id = prr.assignment_action_id
2734: and paa.payroll_action_id = ppa.payroll_action_id

Line 2977: from pay_action_interlocks pai,

2973: paa.assignment_id,
2974: paa_mas.payroll_action_id pre_payroll_action_id,
2975: paa.tax_unit_id run_tax_unit_id,
2976: paa_mas.chunk_number pre_chunk_number
2977: from pay_action_interlocks pai,
2978: pay_assignment_actions paa,
2979: pay_assignment_actions paa_mas
2980: where pai.locking_action_id = paa_mas.assignment_action_id
2981: and paa_mas.assignment_action_id = p_action

Line 2984: from pay_action_interlocks pai2,

2980: where pai.locking_action_id = paa_mas.assignment_action_id
2981: and paa_mas.assignment_action_id = p_action
2982: and pai.locked_action_id = paa.assignment_action_id
2983: and exists (select ''
2984: from pay_action_interlocks pai2,
2985: pay_assignment_actions paa2
2986: where pai2.locking_action_id = paa_mas.assignment_action_id
2987: and pai2.locked_action_id = paa2.assignment_action_id
2988: and paa2.tax_unit_id <> paa.tax_unit_id)

Line 2999: from pay_action_interlocks pai,

2995: paa.tax_unit_id run_tax_unit_id,
2996: paa_mas.chunk_number pre_chunk_number,
2997: paa.start_date start_date,
2998: paa.end_date end_date
2999: from pay_action_interlocks pai,
3000: pay_assignment_actions paa,
3001: pay_assignment_actions paa_mas
3002: where pai.locking_action_id = paa_mas.assignment_action_id
3003: and paa_mas.assignment_action_id = p_action

Line 3010: -- from pay_action_interlocks pai2,

3006: -- North America can only handle child actions on
3007: -- multiple assignment payrolls
3008: --
3009: --and exists (select ''
3010: -- from pay_action_interlocks pai2,
3011: -- pay_assignment_actions paa2
3012: -- where pai2.locking_action_id = paa_mas.assignment_action_id
3013: -- and pai2.locked_action_id = paa2.assignment_action_id
3014: -- and paa2.assignment_id <> paa.assignment_id)

Line 3403: pay_action_interlocks pai,

3399: from pay_payroll_actions ppa_pru,
3400: pay_payroll_actions ppa_pre,
3401: pay_assignment_actions paa_pru,
3402: pay_assignment_actions paa_pre,
3403: pay_action_interlocks pai,
3404: pay_pre_payments ppp
3405: where
3406: paa_pru.assignment_action_id = p_asg_act
3407: and ppa_pru.payroll_action_id = paa_pru.payroll_action_id