APPS.AR_CMGT_PARTY_SEARCH dependencies on HZ_MATCHED_PARTIES_GT

Line 89: FROM HZ_MATCHED_PARTIES_GT GT,

85: LOC.ADDRESS2,LOC.ADDRESS3,LOC.ADDRESS4,LOC.CITY,LOC.COUNTY,
86: LOC.STATE,LOC.PROVINCE,LOC.POSTAL_CODE,
87: TERR.TERRITORY_SHORT_NAME ) CONCATENATED_ADDRESS
88: , score
89: FROM HZ_MATCHED_PARTIES_GT GT,
90: HZ_PARTIES HZP,
91: HZ_CUST_ACCOUNTS CA,
92: HZ_CUST_ACCT_SITES CAS,
93: HZ_LOCATIONS LOC,

Line 162: -- HZ_MATCHED_PARTIES_GT

158: arp_standard.debug('l_msg_count: '||l_msg_count);
159: arp_standard.debug('l_msg_data: '||l_msg_data);
160: -- 3. Setup the SEARCH_RESULTS block to show the
161: -- results. This block is based on the Global Temporary Table
162: -- HZ_MATCHED_PARTIES_GT
163:
164: p_search_context_id := l_search_context_id;
165: p_return_status := l_return_status;
166: p_msg_count := l_msg_count;