3440: AND hzps.party_id = hzmps.party_id
3441: AND nvl(hzps.status,'A') = 'A' --bug# 3319259
3442: ORDER BY score desc, hzps.creation_date desc;
3443:
3444: -- Cursor for getting matched contacts from hz_matched_contacts_gt
3445: CURSOR C_matched_contacts
3446: IS
3447: SELECT hzmc.party_id, hzmc.org_contact_id, score , hzoc.creation_date
3448: FROM hz_matched_contacts_gt hzmc, hz_org_contacts hzoc
3444: -- Cursor for getting matched contacts from hz_matched_contacts_gt
3445: CURSOR C_matched_contacts
3446: IS
3447: SELECT hzmc.party_id, hzmc.org_contact_id, score , hzoc.creation_date
3448: FROM hz_matched_contacts_gt hzmc, hz_org_contacts hzoc
3449: WHERE search_context_id = l_search_context_id
3450: AND hzmc.org_contact_id = hzoc.org_contact_id
3451: AND nvl(hzoc.status,'A') = 'A' --bug# 3319259
3452: ORDER BY score desc, hzoc.creation_date desc;