DBA Data[Home] [Help]

APPS.HR_PRE_PAY dependencies on PAY_PRE_PAYMENTS_S

Line 34: source_action_id pay_pre_payments.source_action_id%type,

30: assignment_action_id pay_pre_payments.assignment_action_id%type,
31: org_payment_method_id pay_pre_payments.org_payment_method_id%type,
32: value pay_pre_payments.value%type,
33: base_currency_value pay_pre_payments.base_currency_value%type,
34: source_action_id pay_pre_payments.source_action_id%type,
35: prepayment_action_id pay_pre_payments.prepayment_action_id%type,
36: organization_id pay_pre_payments.organization_id%type,
37: payees_org_payment_method_id pay_pre_payments.payees_org_payment_method_id%type,
38: effective_date pay_pre_payments.effective_date%type,

Line 438: select pay_pre_payments_s.nextval

434: --
435: if (g_pre_payments(cnt).value <> 0
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;

Line 819: values (pay_pre_payments_s.nextval,

815: assignment_action_id,
816: organization_id,
817: payees_org_payment_method_id,
818: effective_date)
819: values (pay_pre_payments_s.nextval,
820: personal_method,
821: org_method,
822: validation_value,
823: 0,

Line 3513: select pay_pre_payments_s.nextval

3509: begin
3510: --
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