APPS.PYCADAR_PKG dependencies on DUAL

Line 302: from dual

298: cp_deposit_end_date in date,
299: cp_consolidation_set_id in number
300: ) is
301: select 1
302: from dual
303: where exists
304: (select 1
305: from pay_action_interlocks pai_mag,
306: pay_assignment_actions paa_mag,

Line 319: from dual

315: );
316:
317: cursor c_no_prepayments (cp_prepayment_action_id in number) is
318: select 1
319: from dual
320: where not exists
321: (select 1
322: from pay_pre_payments ppp
323: where ppp.assignment_action_id = cp_prepayment_action_id

Line 751: from dual;

747:
748: hr_utility.set_location('procdar',3);
749: select pay_assignment_actions_s.nextval
750: into lockingactid
751: from dual;
752:
753: -- insert the action record.
754: hr_nonrun_asact.insact(lockingactid,assignid,
755: pactid,chunk,greid);

Line 844: from dual;

840:
841: hr_utility.set_location('procdar',6);
842: select pay_assignment_actions_s.nextval
843: into ln_deposit_action_id
844: from dual;
845:
846: -- insert the action record.
847: hr_nonrun_asact.insact(ln_deposit_action_id,
848: ln_assignment_id,

Line 1006: from dual;

1002:
1003: hr_utility.set_location('pycadar archive_action_creation',3);
1004: select pay_assignment_actions_s.nextval
1005: into ln_deposit_action_id
1006: from dual;
1007:
1008: -- insert the action record.
1009: hr_nonrun_asact.insact(ln_deposit_action_id,
1010: ln_assignment_id,