APPS.HZ_PARTY_SEARCH_BO_PUB dependencies on HZ_ORIG_SYS_REF_OBJ_TBL

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 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;