DBA Data[Home] [Help]

APPS.HZ_PARTY_SEARCH_BO_PUB dependencies on HZ_MATCHED_PARTIES_GT

Line 95: FROM hz_matched_parties_gt mpgt, hz_parties hzp

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;
98:
99: -- Cursor to select all the matching parties with 'within' clause

Line 165: FROM hz_matched_parties_gt mpgt, hz_parties hzp

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;
168:
169: BEGIN