DBA Data[Home] [Help]

APPS.AS_IMPORT_SL_PVT dependencies on HZ_MATCHED_CONTACTS_GT

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

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

Line 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;