DBA Data[Home] [Help]

APPS.PER_CALENDAR_ENTRIES_LOAD_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 47: from HR_ALL_ORGANIZATION_UNITS HOU

43: cursor CSR_BUS_GRP (
44: X_BUS_GRP_NAME in VARCHAR2
45: )is
46: select HOU.BUSINESS_GROUP_ID
47: from HR_ALL_ORGANIZATION_UNITS HOU
48: where HOU.NAME = X_BUS_GRP_NAME
49: and HOU.ORGANIZATION_ID = HOU.BUSINESS_GROUP_ID;
50:
51: cursor CSR_ORG_STRUCT (