DBA Data[Home] [Help]

APPS.IBY_PAYMENT_FORMAT_VAL_PVT dependencies on FV_OPERATING_UNITS_ALL

Line 1857: l_fed_employer_id_number fv_operating_units_all.fed_employer_id_number%TYPE;

1853: l_message VARCHAR2(1000);
1854: l_module_name VARCHAR2(200) := g_module_name || 'FEDERAL_ID_NUMBER';
1855: l_org_id number;
1856: l_org_name hr_all_organization_units.name%TYPE;
1857: l_fed_employer_id_number fv_operating_units_all.fed_employer_id_number%TYPE;
1858:
1859: BEGIN
1860: x_error_code := g_SUCCESS;
1861:

Line 1876: from fv_operating_units_all

1872:
1873:
1874: select fed_employer_id_number
1875: into l_fed_employer_id_number
1876: from fv_operating_units_all
1877: where org_id = l_org_id;
1878:
1879: IF l_fed_employer_id_number IS NULL THEN -- l_fed_employer_id_number should not be null
1880: