DBA Data[Home] [Help]

APPS.IGI_CIS2007_IGIPPADR_PKG dependencies on HR_OPERATING_UNITS

Line 83: l_org_id HR_OPERATING_UNITS.organization_id%TYPE := null;

79: return(l_print_type);
80: end get_PRINT_TYPE;
81: --------------------------------------------------------------------------------
82: function get_ORG_NAME return varchar2 is
83: l_org_id HR_OPERATING_UNITS.organization_id%TYPE := null;
84: l_org_name HR_OPERATING_UNITS.name%TYPE := null;
85: begin
86: l_org_id := MO_GLOBAL.get_current_org_id;
87: select name

Line 84: l_org_name HR_OPERATING_UNITS.name%TYPE := null;

80: end get_PRINT_TYPE;
81: --------------------------------------------------------------------------------
82: function get_ORG_NAME return varchar2 is
83: l_org_id HR_OPERATING_UNITS.organization_id%TYPE := null;
84: l_org_name HR_OPERATING_UNITS.name%TYPE := null;
85: begin
86: l_org_id := MO_GLOBAL.get_current_org_id;
87: select name
88: into l_org_name

Line 89: from hr_operating_units

85: begin
86: l_org_id := MO_GLOBAL.get_current_org_id;
87: select name
88: into l_org_name
89: from hr_operating_units
90: where organization_id = l_org_id;
91: return(l_org_name);
92: exception
93: WHEN no_data_found THEN