DBA Data[Home] [Help]

APPS.GMF_SUBLED_REP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 161: SELECT name INTO l_Orgname FROM hr_all_organization_units WHERE organization_id = p_org_id;

157: l_Orgname VARCHAR2(300):= '';
158:
159: BEGIN
160:
161: SELECT name INTO l_Orgname FROM hr_all_organization_units WHERE organization_id = p_org_id;
162:
163: RETURN l_Orgname;
164:
165: EXCEPTION