APPS.OZF_PRE_PROCESS_PVT dependencies on HZ_MATCHED_PARTIES_GT

Line 5954: -- Cursor for getting matched party_id from hz_matched_parties_gt

5950:
5951: l_api_name CONSTANT VARCHAR2(30) := 'DQM_processing';
5952: l_api_version_number CONSTANT NUMBER := 1.0;
5953:
5954: -- Cursor for getting matched party_id from hz_matched_parties_gt
5955: CURSOR C_matched_party ( pc_search_id NUMBER)
5956: IS
5957: SELECT party_id
5958: FROM ( SELECT hzmp.party_id,

Line 5960: FROM hz_matched_parties_gt hzmp,

5956: IS
5957: SELECT party_id
5958: FROM ( SELECT hzmp.party_id,
5959: score
5960: FROM hz_matched_parties_gt hzmp,
5961: hz_parties hzp
5962: WHERE search_context_id = pc_search_id
5963: AND hzp.party_id = hzmp.party_id
5964: ORDER BY score desc, hzp.creation_date desc )