APPS.PER_ASS_STATUSES_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 40: from HR_ALL_ORGANIZATION_UNITS ORG

36: cursor CSR_BUSINESS_GROUP (
37: X_NAME in VARCHAR2
38: ) is
39: select ORG.ORGANIZATION_ID
40: from HR_ALL_ORGANIZATION_UNITS ORG
41: ,HR_ORGANIZATION_INFORMATION OI1
42: where ORG.ORGANIZATION_ID = OI1.ORGANIZATION_ID
43: and OI1.ORG_INFORMATION_CONTEXT = 'CLASS'
44: and OI1.ORG_INFORMATION1 = 'HR_BG'

Line 243: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS', PER_RIC_PKG.column_info_tbl(

239: p_entity_name => 'PER_ASS_STATUS_TYPE_AMENDS',
240: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
241: PER_RIC_PKG.ref_info_rec('PER_ASSIGNMENT_STATUS_TYPES', PER_RIC_PKG.column_info_tbl(
242: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,P_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
243: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS', PER_RIC_PKG.column_info_tbl(
244: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,P_BUSINESS_GROUP_ID,NULL)))
245: ),
246: p_ref_type => 'INS');
247: