220:
221: -- Get the Org Name
222: CURSOR org_csr (p_org_id IN NUMBER) IS
223: SELECT HOU.name
224: FROM HR_OPERATING_UNITS HOU
225: WHERE HOU.organization_id = p_org_id;
226:
227: l_org_id NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();
228:
1596:
1597: -- Get the Org Name
1598: CURSOR org_csr (p_org_id IN NUMBER) IS
1599: SELECT HOU.name
1600: FROM HR_OPERATING_UNITS HOU
1601: WHERE HOU.organization_id = p_org_id;
1602:
1603:
1604: l_org_id NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();