APPS.IBY_PAYMENT_FORMAT_VAL_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1843: l_org_name hr_all_organization_units.name%TYPE;

1839: )IS
1840: l_message VARCHAR2(1000);
1841: l_module_name VARCHAR2(200) := g_module_name || 'FEDERAL_ID_NUMBER';
1842: l_org_id number;
1843: l_org_name hr_all_organization_units.name%TYPE;
1844: l_fed_employer_id_number fv_operating_units_all.fed_employer_id_number%TYPE;
1845:
1846: BEGIN
1847: x_error_code := g_SUCCESS;

Line 1856: hr_all_organization_units haou

1852:
1853: select ipia.org_id, haou.name
1854: into l_org_id, l_org_name
1855: from iby_pay_instructions_all ipia,
1856: hr_all_organization_units haou
1857: where ipia.payment_instruction_id = p_pay_instruction_id
1858: and ipia.org_id = haou.organization_id;
1859:
1860: