APPS.IBY_PAYMENT_FORMAT_VAL_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1856: l_org_name hr_all_organization_units.name%TYPE;

1852: )IS
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;

Line 1869: hr_all_organization_units haou

1865:
1866: select ipia.org_id, haou.name
1867: into l_org_id, l_org_name
1868: from iby_pay_instructions_all ipia,
1869: hr_all_organization_units haou
1870: where ipia.payment_instruction_id = p_pay_instruction_id
1871: and ipia.org_id = haou.organization_id;
1872:
1873: