DBA Data[Home] [Help]

APPS.IBY_PAYMENT_FORMAT_VAL_PVT dependencies on FV_OPERATING_UNITS_ALL

Line 1844: l_fed_employer_id_number fv_operating_units_all.fed_employer_id_number%TYPE;

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;
1848:

Line 1863: from fv_operating_units_all

1859:
1860:
1861: select fed_employer_id_number
1862: into l_fed_employer_id_number
1863: from fv_operating_units_all
1864: where org_id = l_org_id;
1865:
1866: IF l_fed_employer_id_number IS NULL THEN -- l_fed_employer_id_number should not be null
1867: