DBA Data[Home] [Help]

APPS.IGI_CIS_IGIPMTHP_PKG dependencies on HR_OPERATING_UNITS

Line 256: l_org_id hr_operating_units.organization_id%TYPE := NULL ;

252:
253:
254: FUNCTION get_org_name RETURN VARCHAR2 IS
255: l_procedure_name VARCHAR2(100):='.get_org_name';
256: l_org_id hr_operating_units.organization_id%TYPE := NULL ;
257: l_org_name hr_operating_units.name%TYPE := NULL ;
258: BEGIN
259: l_procedure_name := g_path_name || l_procedure_name;
260: log(C_STATE_LEVEL, l_procedure_name, 'BEGIN');

Line 257: l_org_name hr_operating_units.name%TYPE := NULL ;

253:
254: FUNCTION get_org_name RETURN VARCHAR2 IS
255: l_procedure_name VARCHAR2(100):='.get_org_name';
256: l_org_id hr_operating_units.organization_id%TYPE := NULL ;
257: l_org_name hr_operating_units.name%TYPE := NULL ;
258: BEGIN
259: l_procedure_name := g_path_name || l_procedure_name;
260: log(C_STATE_LEVEL, l_procedure_name, 'BEGIN');
261: -- l_org_id := fnd_profile.value('ORG_ID');

Line 270: FROM hr_operating_units

266: end if;
267:
268: SELECT name
269: INTO l_org_name
270: FROM hr_operating_units
271: WHERE organization_id = l_org_id;
272:
273: log(C_STATE_LEVEL, l_procedure_name, 'END');
274: RETURN(l_org_name);