DBA Data[Home] [Help]

APPS.IGI_CIS2007_IGIPPADR_PKG dependencies on HR_OPERATING_UNITS

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

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

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

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

Line 91: from hr_operating_units

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