1625: select
1626: otl.name into org_name
1627: from
1628: hr_all_organization_units o,
1629: hr_all_organization_units_tl otl
1630: where
1631: o.organization_id = otl.organization_id
1632: and otl.language = userenv('LANG')
1633: and o.organization_id = p_org_id;
1977: select
1978: otl.name into org_name
1979: from
1980: hr_all_organization_units o,
1981: hr_all_organization_units_tl otl
1982: where
1983: o.organization_id = otl.organization_id
1984: and otl.language = userenv('LANG')
1985: and o.organization_id = (