APPS.HZ_PARTY_SEARCH_BO_PUB dependencies on HZ_ORIG_SYS_REF_OBJ

Line 51: SELECT HZ_ORIG_SYS_REF_OBJ(

47: ,hzp.primary_phone_area_code
48: ,hzp.primary_phone_number
49: ,hzp.email_address
50: ,CAST (MULTISET (
51: SELECT HZ_ORIG_SYS_REF_OBJ(
52: NULL, --P_ACTION_TYPE,
53: ORIG_SYSTEM_REF_ID,
54: ORIG_SYSTEM,
55: ORIG_SYSTEM_REFERENCE,

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

89: ATTRIBUTE20)
90: FROM HZ_ORIG_SYS_REFERENCES OSR
91: WHERE OSR.OWNER_TABLE_ID = HZP.PARTY_ID
92: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
93: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL)
94: ) AS HZ_MATCHED_PARTY_OBJ_TBL
95: FROM hz_matched_parties_gt mpgt, hz_parties hzp
96: WHERE mpgt.party_id = hzp.party_id
97: AND mpgt.search_context_id = l_search_ctx_id;

Line 120: SELECT HZ_ORIG_SYS_REF_OBJ(

116: ,hzp.primary_phone_area_code
117: ,hzp.primary_phone_number
118: ,hzp.email_address
119: ,CAST (MULTISET (
120: SELECT HZ_ORIG_SYS_REF_OBJ(
121: NULL, --P_ACTION_TYPE,
122: ORIG_SYSTEM_REF_ID,
123: ORIG_SYSTEM,
124: ORIG_SYSTEM_REFERENCE,

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

159: FROM HZ_ORIG_SYS_REFERENCES OSR
160: WHERE OSR.OWNER_TABLE_ID = HZP.PARTY_ID
161: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
162: AND OSR.ORIG_SYSTEM = l_within_os
163: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL)
164: ) AS HZ_MATCHED_PARTY_OBJ_TBL
165: FROM hz_matched_parties_gt mpgt, hz_parties hzp
166: WHERE mpgt.party_id = hzp.party_id
167: AND mpgt.search_context_id = l_search_ctx_id;