[Home] [Help]
377: )
378: AND NOT EXISTS (SELECT NULL
379: FROM pay_assignment_actions paa_arch
380: ,pay_payroll_actions ppa_arch
381: ,pay_action_interlocks intk
382: WHERE paa_arch.payroll_action_id = ppa_arch.payroll_action_id
383: AND intk.locked_action_id = paa_init.assignment_action_id
384: AND intk.locking_action_id = paa_arch.assignment_action_id
385: AND paf.assignment_id = paa_arch.assignment_id
1241: IS
1242: select count(paa.assignment_action_id)
1243: from pay_payroll_actions ppa
1244: ,pay_assignment_actions paa
1245: ,pay_action_interlocks pal
1246: where pal.locking_action_id=p_prepayment_lcking_id
1247: and paa.assignment_action_id=pal.locked_action_id
1248: and ppa.payroll_action_id=paa.payroll_action_id
1249: and ppa.action_type in ('Q','R')
1257: ,ppa.date_earned date_earned
1258: ,ppa.effective_date effective_date
1259: from pay_payroll_actions ppa
1260: ,pay_assignment_actions paa
1261: ,pay_action_interlocks pal
1262: where pal.locking_action_id=p_prepayment_lcking_id
1263: and paa.assignment_action_id=pal.locked_action_id
1264: and ppa.payroll_action_id=paa.payroll_action_id
1265: and ppa.action_type in ('Q','R')
4256: ,ppa_init.payroll_action_id init_payroll_action_id
4257: ,ppa_init.effective_date init_effective_date
4258: ,paa_arch.assignment_id
4259: FROM pay_assignment_actions paa_arch
4260: ,pay_action_interlocks intk
4261: ,pay_assignment_actions paa_init
4262: ,pay_payroll_actions ppa_init
4263: WHERE paa_arch.assignment_action_id = p_init_arch_action_id
4264: AND intk.locking_action_id = paa_arch.assignment_action_id
4287: ,ptp.start_date period_start_date
4288: ,ptp.regular_payment_date
4289: FROM pay_assignment_actions paa_arch_mst
4290: ,pay_assignment_actions paa_arch_chd
4291: ,pay_action_interlocks pai_pre
4292: ,pay_assignment_actions paa_pre
4293: ,pay_payroll_actions ppa_pre
4294: ,per_business_groups pbg
4295: ,pay_action_interlocks pai_run
4291: ,pay_action_interlocks pai_pre
4292: ,pay_assignment_actions paa_pre
4293: ,pay_payroll_actions ppa_pre
4294: ,per_business_groups pbg
4295: ,pay_action_interlocks pai_run
4296: ,pay_assignment_actions paa_run
4297: ,pay_payroll_actions ppa_run
4298: ,per_time_periods ptp
4299: WHERE paa_arch_mst.assignment_action_id = p_master_aa_id
4322: AND paa_run.action_sequence =
4323: (
4324: SELECT MAX(paa_run2.action_sequence)
4325: FROM pay_assignment_actions paa_run2
4326: ,pay_action_interlocks pai_run2
4327: WHERE pai_run2.locking_action_id = paa_arch_chd.assignment_action_id
4328: AND pai_run2.locked_action_id = paa_run2.assignment_action_id
4329: );
4330:
4335: IS
4336: select count(paa.assignment_action_id)
4337: from pay_payroll_actions ppa
4338: ,pay_assignment_actions paa
4339: ,pay_action_interlocks pal
4340: where pal.locking_action_id=p_prepayment_lcking_id
4341: and paa.assignment_action_id=pal.locked_action_id
4342: and ppa.payroll_action_id=paa.payroll_action_id
4343: and ppa.action_type in ('Q','R')
4353: select paa.assignment_action_id
4354: ,ppa.date_earned
4355: from pay_payroll_actions ppa
4356: ,pay_assignment_actions paa
4357: ,pay_action_interlocks pal
4358: where pal.locking_action_id=p_prepayment_lcking_id
4359: and paa.assignment_action_id=pal.locked_action_id
4360: and ppa.payroll_action_id=paa.payroll_action_id
4361: and ppa.action_type in ('Q','R')
4370: ,c_payroll_date date)
4371: IS
4372: SELECT paa.assignment_action_id
4373: FROM pay_payroll_actions ppa,pay_assignment_actions paa,
4374: pay_action_interlocks pai1,pay_action_interlocks pai2
4375:
4376: WHERE ppa.PAYROLL_ACTION_ID = paa.PAYROLL_ACTION_ID
4377: AND paa.ASSIGNMENT_ID = c_assignment_id
4378: AND paa.payroll_action_id = ppa.payroll_action_id