APPS.IGI_CIS2007_IGIPSUPR_PKG dependencies on HR_OPERATING_UNITS

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

94:
95: END get_p_report_title;
96:
97: FUNCTION get_p_org_name RETURN VARCHAR2 IS
98: l_org_id hr_operating_units.organization_id%TYPE := NULL;
99: l_org_name hr_operating_units.NAME%TYPE := NULL;
100: BEGIN
101: BEGIN
102: l_org_id := MO_GLOBAL.get_current_org_id;

Line 99: l_org_name hr_operating_units.NAME%TYPE := NULL;

95: END get_p_report_title;
96:
97: FUNCTION get_p_org_name RETURN VARCHAR2 IS
98: l_org_id hr_operating_units.organization_id%TYPE := NULL;
99: l_org_name hr_operating_units.NAME%TYPE := NULL;
100: BEGIN
101: BEGIN
102: l_org_id := MO_GLOBAL.get_current_org_id;
103:

Line 106: FROM hr_operating_units

102: l_org_id := MO_GLOBAL.get_current_org_id;
103:
104: SELECT NAME
105: INTO l_org_name
106: FROM hr_operating_units
107: WHERE organization_id = l_org_id;
108:
109: EXCEPTION
110: WHEN no_data_found THEN