[Home] [Help]
323: cp_deposit_end_date in date,
324: cp_consolidation_set_id in number
325: ) is
326: select 1
327: from dual
328: where exists
329: (select 1
330: from pay_action_interlocks pai_mag,
331: pay_assignment_actions paa_mag,
352: );
353:
354: cursor c_no_prepayments (cp_prepayment_action_id in number) is
355: select 1
356: from dual
357: where not exists
358: (select 1
359: from pay_pre_payments ppp
360: where ppp.assignment_action_id = cp_prepayment_action_id
784:
785: hr_utility.set_location('procdar',3);
786: select pay_assignment_actions_s.nextval
787: into lockingactid
788: from dual;
789:
790: -- insert the action record.
791: hr_nonrun_asact.insact(lockingactid,assignid,
792: pactid,chunk,greid);
877:
878: hr_utility.set_location('procdar',6);
879: select pay_assignment_actions_s.nextval
880: into ln_deposit_action_id
881: from dual;
882:
883: -- insert the action record.
884: hr_nonrun_asact.insact(ln_deposit_action_id,
885: ln_assignment_id,
988: /*Added the following cursor to check if any non void payments exist
989: for given archiver action id for bug 16387461*/
990: cursor c_non_void_pymts (cp_action_id in number) is
991: select 1
992: from dual
993: where exists
994: (select 1
995: from PAY_EMP_NET_DIST_ACTION_INFO_V net_pay,
996: pay_assignment_actions paa_mag,
1076:
1077: hr_utility.set_location('pycadar archive_action_creation',3);
1078: select pay_assignment_actions_s.nextval
1079: into ln_deposit_action_id
1080: from dual;
1081:
1082: -- insert the action record.
1083: hr_nonrun_asact.insact(ln_deposit_action_id,
1084: ln_assignment_id,
1611:
1612: BEGIN
1613: SELECT '1'
1614: INTO lv_rev_run_exists
1615: FROM dual
1616: where exists
1617: (Select /*+ ORDERED */ 1
1618: from pay_action_interlocks pai_run, --Pre > Run
1619: pay_action_interlocks pai_rev, --Run > Rev