[Home] [Help]
307: )
308: AND NOT EXISTS (SELECT NULL
309: FROM pay_assignment_actions paa_arch
310: ,pay_payroll_actions ppa_arch
311: ,pay_action_interlocks intk
312: WHERE paa_arch.payroll_action_id = ppa_arch.payroll_action_id
313: AND intk.locked_action_id = paa_init.assignment_action_id
314: AND intk.locking_action_id = paa_arch.assignment_action_id
315: AND paf.assignment_id = paa_arch.assignment_id
1168: IS
1169: select count(paa.assignment_action_id)
1170: from pay_payroll_actions ppa
1171: ,pay_assignment_actions paa
1172: ,pay_action_interlocks pal
1173: where pal.locking_action_id=p_prepayment_lcking_id
1174: and paa.assignment_action_id=pal.locked_action_id
1175: and ppa.payroll_action_id=paa.payroll_action_id
1176: and ppa.action_type in ('Q','R')
1184: ,ppa.date_earned date_earned
1185: ,ppa.effective_date effective_date
1186: from pay_payroll_actions ppa
1187: ,pay_assignment_actions paa
1188: ,pay_action_interlocks pal
1189: where pal.locking_action_id=p_prepayment_lcking_id
1190: and paa.assignment_action_id=pal.locked_action_id
1191: and ppa.payroll_action_id=paa.payroll_action_id
1192: and ppa.action_type in ('Q','R')
4036: ,ppa_init.payroll_action_id init_payroll_action_id
4037: ,ppa_init.effective_date init_effective_date
4038: ,paa_arch.assignment_id
4039: FROM pay_assignment_actions paa_arch
4040: ,pay_action_interlocks intk
4041: ,pay_assignment_actions paa_init
4042: ,pay_payroll_actions ppa_init
4043: WHERE paa_arch.assignment_action_id = p_init_arch_action_id
4044: AND intk.locking_action_id = paa_arch.assignment_action_id
4067: ,ptp.regular_payment_date
4068: FROM pay_assignment_actions paa_arch_chd
4069: ,pay_assignment_actions paa_arch_mst
4070: ,pay_assignment_actions paa_pre
4071: ,pay_action_interlocks pai_pre
4072: ,pay_assignment_actions paa_run
4073: ,pay_action_interlocks pai_run
4074: ,pay_payroll_actions ppa_pre
4075: ,pay_payroll_actions ppa_run
4069: ,pay_assignment_actions paa_arch_mst
4070: ,pay_assignment_actions paa_pre
4071: ,pay_action_interlocks pai_pre
4072: ,pay_assignment_actions paa_run
4073: ,pay_action_interlocks pai_run
4074: ,pay_payroll_actions ppa_pre
4075: ,pay_payroll_actions ppa_run
4076: ,per_time_periods ptp
4077: ,per_business_groups pbg
4097: AND paa_run.action_sequence =
4098: (
4099: SELECT MAX(paa_run2.action_sequence)
4100: FROM pay_assignment_actions paa_run2
4101: ,pay_action_interlocks pai_run2
4102: WHERE pai_run2.locking_action_id = paa_arch_chd.assignment_action_id
4103: AND pai_run2.locked_action_id = paa_run2.assignment_action_id
4104: );
4105:
4110: IS
4111: select count(paa.assignment_action_id)
4112: from pay_payroll_actions ppa
4113: ,pay_assignment_actions paa
4114: ,pay_action_interlocks pal
4115: where pal.locking_action_id=p_prepayment_lcking_id
4116: and paa.assignment_action_id=pal.locked_action_id
4117: and ppa.payroll_action_id=paa.payroll_action_id
4118: and ppa.action_type in ('Q','R')
4128: select paa.assignment_action_id
4129: ,ppa.date_earned
4130: from pay_payroll_actions ppa
4131: ,pay_assignment_actions paa
4132: ,pay_action_interlocks pal
4133: where pal.locking_action_id=p_prepayment_lcking_id
4134: and paa.assignment_action_id=pal.locked_action_id
4135: and ppa.payroll_action_id=paa.payroll_action_id
4136: and ppa.action_type in ('Q','R')
4145: ,c_payroll_date date)
4146: IS
4147: SELECT paa.assignment_action_id
4148: FROM pay_payroll_actions ppa,pay_assignment_actions paa,
4149: pay_action_interlocks pai1,pay_action_interlocks pai2
4150:
4151: WHERE ppa.PAYROLL_ACTION_ID = paa.PAYROLL_ACTION_ID
4152: AND paa.ASSIGNMENT_ID = c_assignment_id
4153: AND paa.payroll_action_id = ppa.payroll_action_id