DBA Data[Home] [Help]

APPS.HR_PRE_PAY dependencies on DUAL

Line 440: from dual;

436: or g_pre_payments(cnt).category = 'MT') then
437: --
438: select pay_pre_payments_s.nextval
439: into payment_id
440: from dual;
441: --
442: g_pre_payments(cnt).pre_payment_id := payment_id;
443: --
444: insert into pay_pre_payments

Line 3046: from dual;

3042: if (prev_tu <> turec.run_tax_unit_id) then
3043: --
3044: select pay_assignment_actions_s.nextval
3045: into pre_tu_actid
3046: from dual;
3047: --
3048: hr_nonrun_asact.insact(pre_tu_actid,
3049: turec.assignment_id,
3050: turec.pre_payroll_action_id,

Line 3090: from dual;

3086: --
3087: if (prev_asg_id <> asgrec.assignment_id) then
3088: select pay_assignment_actions_s.nextval
3089: into pre_asg_actid
3090: from dual;
3091: --
3092: hr_nonrun_asact.insact(pre_asg_actid,
3093: asgrec.assignment_id,
3094: asgrec.pre_payroll_action_id,

Line 3477: from dual;

3473: for totrec in get_totals(p_pactid) loop
3474: --
3475: select pay_pre_payments_s.nextval
3476: into l_pre_pay_id
3477: from dual;
3478: --
3479: insert into pay_pre_payments
3480: (pre_payment_id,
3481: org_payment_method_id,