[Home] [Help]
306: cp_deposit_end_date in date,
307: cp_consolidation_set_id in number
308: ) is
309: select 1
310: from dual
311: where exists
312: (select 1
313: from pay_action_interlocks pai_mag,
314: pay_assignment_actions paa_mag,
337: and ppa_mag.ORG_PAYMENT_METHOD_ID = popm.org_payment_method_id);
338:
339: cursor c_no_prepayments (cp_prepayment_action_id in number) is
340: select 1
341: from dual
342: where not exists
343: (select 1
344: from pay_pre_payments ppp ,
345: pay_org_payment_methods_f popm
460:
461: BEGIN
462: SELECT '1'
463: INTO lv_rev_run_exists
464: FROM dual
465: where exists
466: (Select /*+ ORDERED */ 1
467: from pay_action_interlocks pai_run, --Pre > Run
468: pay_action_interlocks pai_rev, --Run > Rev
626:
627: hr_utility.set_location('procdar archive',3);
628: select pay_assignment_actions_s.nextval
629: into ln_deposit_action_id
630: from dual;
631:
632: -- insert the action record.
633: hr_nonrun_asact.insact(ln_deposit_action_id,
634: ln_assignment_id,
1033:
1034: hr_utility.set_location('procdar',3);
1035: select pay_assignment_actions_s.nextval
1036: into ln_deposit_action_id
1037: from dual;
1038:
1039: -- insert the action record.
1040: hr_nonrun_asact.insact(ln_deposit_action_id,
1041: ln_assignment_id,
1076: ln_prev_pre_pymt_action_id <> ln_pre_pymt_action_id) then
1077: hr_utility.set_location('procdar',6);
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,