APPS.IGI_CIS_IGIPMTHP_PKG dependencies on HR_OPERATING_UNITS

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

173: END get_print_type;
174:
175:
176: FUNCTION get_org_name RETURN VARCHAR2 IS
177: l_org_id hr_operating_units.organization_id%TYPE := NULL ;
178: l_org_name hr_operating_units.name%TYPE := NULL ;
179: BEGIN
180: l_org_id := fnd_profile.value('ORG_ID');
181:

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

174:
175:
176: FUNCTION get_org_name RETURN VARCHAR2 IS
177: l_org_id hr_operating_units.organization_id%TYPE := NULL ;
178: l_org_name hr_operating_units.name%TYPE := NULL ;
179: BEGIN
180: l_org_id := fnd_profile.value('ORG_ID');
181:
182: SELECT name

Line 184: FROM hr_operating_units

180: l_org_id := fnd_profile.value('ORG_ID');
181:
182: SELECT name
183: INTO l_org_name
184: FROM hr_operating_units
185: WHERE organization_id = l_org_id;
186:
187: RETURN(l_org_name);
188: EXCEPTION