DBA Data[Home] [Help]

APPS.OZF_PRE_PROCESS_PVT dependencies on HZ_MATCHED_CONTACTS_GT

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

6430: AND hzps.party_site_id = hzmps.party_site_id
6431: AND hzps.party_id = hzmps.party_id
6432: ORDER BY score desc, hzps.creation_date desc;
6433:
6434: -- Cursor for getting matched contacts from hz_matched_contacts_gt
6435: CURSOR C_matched_contacts ( pc_search_id NUMBER)
6436: IS
6437: SELECT hzmc.party_id,
6438: hzmc.org_contact_id,

Line 6440: FROM hz_matched_contacts_gt hzmc

6436: IS
6437: SELECT hzmc.party_id,
6438: hzmc.org_contact_id,
6439: score
6440: FROM hz_matched_contacts_gt hzmc
6441: WHERE search_context_id = pc_search_id;
6442:
6443:
6444: CURSOR get_match_rule ( pc_rule_name VARCHAR2)