DBA Data[Home] [Help]

APPS.AS_IMPORT_SL_PVT dependencies on HZ_MATCHED_CONTACTS_GT

Line 3463: -- Cursor for getting matched contacts from hz_matched_contacts_gt

3459: AND hzps.party_id = hzmps.party_id
3460: AND nvl(hzps.status,'A') = 'A' --bug# 3319259
3461: ORDER BY score desc, hzps.creation_date desc;
3462:
3463: -- Cursor for getting matched contacts from hz_matched_contacts_gt
3464: CURSOR C_matched_contacts
3465: IS
3466: SELECT hzmc.party_id, hzmc.org_contact_id, score , hzoc.creation_date
3467: FROM hz_matched_contacts_gt hzmc, hz_org_contacts hzoc

Line 3467: FROM hz_matched_contacts_gt hzmc, hz_org_contacts hzoc

3463: -- Cursor for getting matched contacts from hz_matched_contacts_gt
3464: CURSOR C_matched_contacts
3465: IS
3466: SELECT hzmc.party_id, hzmc.org_contact_id, score , hzoc.creation_date
3467: FROM hz_matched_contacts_gt hzmc, hz_org_contacts hzoc
3468: WHERE search_context_id = l_search_context_id
3469: AND hzmc.org_contact_id = hzoc.org_contact_id
3470: AND nvl(hzoc.status,'A') = 'A' --bug# 3319259
3471: ORDER BY score desc, hzoc.creation_date desc;