DBA Data[Home] [Help]

APPS.PAY_US_NACHA_TAPE dependencies on HR_ORGANIZATION_UNITS

Line 1525: hr_organization_units hou, hr_organization_information hoi,

1521:
1522: CURSOR csr_get_batch_no IS
1523: SELECT ppp.org_payment_method_id, hou.organization_id, paa.assignment_action_id
1524: FROM pay_pre_payments ppp, pay_org_payment_methods_f opm,
1525: hr_organization_units hou, hr_organization_information hoi,
1526: pay_payroll_actions ppa, pay_assignment_actions paa
1527: WHERE opm.org_payment_method_id = ppp.org_payment_method_id
1528: AND opm.org_payment_method_id = ppa.org_payment_method_id
1529: AND opm.org_payment_method_id = p_org_payment_method_id

Line 1566: ln_org_id hr_organization_units.organization_id%TYPE := -1;

1562:
1563: lr_conc_ident csr_get_conc_ident%ROWTYPE;
1564:
1565: ln_org_pay_method_id pay_pre_payments.org_payment_method_id%TYPE := -1;
1566: ln_org_id hr_organization_units.organization_id%TYPE := -1;
1567: ln_batch_number NUMBER(5) := 0;
1568: lv_return_value VARCHAR2(80) := NULL;
1569:
1570: TYPE lt_identifier_rec_type IS RECORD (ident_name fnd_lookup_values.meaning%TYPE,