APPS.HZ_PARTY_BO_PVT dependencies on HZ_ORIG_SYS_REF_OBJ

Line 1531: SELECT HZ_ORIG_SYS_REF_OBJ(

1527: ADDITIONAL_INFORMATION29, ADDITIONAL_INFORMATION30,
1528: PERCENTAGE_OWNERSHIP,
1529: ACTUAL_CONTENT_SOURCE,
1530: CAST(MULTISET (
1531: SELECT HZ_ORIG_SYS_REF_OBJ(
1532: NULL, --P_ACTION_TYPE,
1533: ORIG_SYSTEM_REF_ID,
1534: ORIG_SYSTEM,
1535: ORIG_SYSTEM_REFERENCE,

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

1553: ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20)
1554: FROM HZ_ORIG_SYS_REFERENCES OSR
1555: WHERE OSR.OWNER_TABLE_ID = REL.SUBJECT_ID
1556: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
1557: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL))
1558: FROM HZ_RELATIONSHIPS REL
1559: WHERE RELATIONSHIP_ID = l_relationship_id
1560: AND DIRECTIONAL_FLAG = 'F';
1561: