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 3084: from dual;

3080: if (prev_tu <> turec.run_tax_unit_id) then
3081: --
3082: select pay_assignment_actions_s.nextval
3083: into pre_tu_actid
3084: from dual;
3085: --
3086: hr_nonrun_asact.insact(pre_tu_actid,
3087: turec.assignment_id,
3088: turec.pre_payroll_action_id,

Line 3128: from dual;

3124: --
3125: if (prev_asg_id <> asgrec.assignment_id) then
3126: select pay_assignment_actions_s.nextval
3127: into pre_asg_actid
3128: from dual;
3129: --
3130: hr_nonrun_asact.insact(pre_asg_actid,
3131: asgrec.assignment_id,
3132: asgrec.pre_payroll_action_id,

Line 3515: from dual;

3511: for totrec in get_totals(p_pactid) loop
3512: --
3513: select pay_pre_payments_s.nextval
3514: into l_pre_pay_id
3515: from dual;
3516: --
3517: insert into pay_pre_payments
3518: (pre_payment_id,
3519: org_payment_method_id,