DBA Data[Home] [Help]

APPS.OKL_AM_VENDOR_RES_SHARE_PVT dependencies on HR_OPERATING_UNITS

Line 224: FROM HR_OPERATING_UNITS HOU

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:

Line 1600: FROM HR_OPERATING_UNITS HOU

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();