APPS.OZF_PRE_PROCESS_PVT dependencies on HZ_MATCHED_PARTIES_GT

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

6403:
6404: l_api_name CONSTANT VARCHAR2(30) := 'DQM_processing';
6405: l_api_version_number CONSTANT NUMBER := 1.0;
6406:
6407: -- Cursor for getting matched party_id from hz_matched_parties_gt
6408: CURSOR C_matched_party ( pc_search_id NUMBER)
6409: IS
6410: SELECT party_id
6411: FROM ( SELECT hzmp.party_id,

Line 6413: FROM hz_matched_parties_gt hzmp,

6409: IS
6410: SELECT party_id
6411: FROM ( SELECT hzmp.party_id,
6412: score
6413: FROM hz_matched_parties_gt hzmp,
6414: hz_parties hzp
6415: WHERE search_context_id = pc_search_id
6416: AND hzp.party_id = hzmp.party_id
6417: ORDER BY score desc, hzp.creation_date desc )