APPS.HZ_EXTRACT_RELATIONSHIP_BO_PVT dependencies on HZ_ORIG_SYS_REF_OBJ

Line 133: SELECT HZ_ORIG_SYS_REF_OBJ(

129: ADDITIONAL_INFORMATION30,
130: PERCENTAGE_OWNERSHIP,
131: ACTUAL_CONTENT_SOURCE,
132: CAST(MULTISET (
133: SELECT HZ_ORIG_SYS_REF_OBJ(
134: NULL, --P_ACTION_TYPE,
135: ORIG_SYSTEM_REF_ID,
136: ORIG_SYSTEM,
137: ORIG_SYSTEM_REFERENCE,

Line 176: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL))

172: FROM HZ_ORIG_SYS_REFERENCES OSR
173: WHERE
174: OSR.OWNER_TABLE_ID = REL.OBJECT_ID
175: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
176: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL))
177: FROM HZ_RELATIONSHIPS REL
178: WHERE SUBJECT_ID = P_SUBJECT_ID;
179:
180: