[Home] [Help]
301: cp_deposit_end_date in date,
302: cp_consolidation_set_id in number
303: ) is
304: select 1
305: from dual
306: where exists
307: (select 1
308: from pay_action_interlocks pai_mag,
309: pay_assignment_actions paa_mag,
332: and ppa_mag.ORG_PAYMENT_METHOD_ID = popm.org_payment_method_id);
333:
334: cursor c_no_prepayments (cp_prepayment_action_id in number) is
335: select 1
336: from dual
337: where not exists
338: (select 1
339: from pay_pre_payments ppp ,
340: pay_org_payment_methods_f popm
455:
456: BEGIN
457: SELECT '1'
458: INTO lv_rev_run_exists
459: FROM dual
460: where exists
461: (Select /*+ ORDERED */ 1
462: from pay_action_interlocks pai_run, --Pre > Run
463: pay_action_interlocks pai_rev, --Run > Rev
616:
617: hr_utility.set_location('procdar archive',3);
618: select pay_assignment_actions_s.nextval
619: into ln_deposit_action_id
620: from dual;
621:
622: -- insert the action record.
623: hr_nonrun_asact.insact(ln_deposit_action_id,
624: ln_assignment_id,
1023:
1024: hr_utility.set_location('procdar',3);
1025: select pay_assignment_actions_s.nextval
1026: into ln_deposit_action_id
1027: from dual;
1028:
1029: -- insert the action record.
1030: hr_nonrun_asact.insact(ln_deposit_action_id,
1031: ln_assignment_id,
1066: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
1067: hr_utility.set_location('procdar',6);
1068: select pay_assignment_actions_s.nextval
1069: into ln_deposit_action_id
1070: from dual;
1071:
1072: -- insert the action record.
1073: hr_nonrun_asact.insact(ln_deposit_action_id,
1074: ln_assignment_id,