DBA Data[Home] [Help]

APPS.FII_AR_COLLECTORS_PKG dependencies on HZ_MERGE_DICTIONARY

Line 130: hz_merge_dictionary d

126:
127: select nvl(max(batch_party_id), -1)
128: into l_max_batch_party_id
129: from hz_merge_party_history m,
130: hz_merge_dictionary d
131: where m.merge_dict_id = d.merge_dict_id
132: and d.entity_name = 'HZ_PARTIES';
133:
134: INSERT INTO fii_change_log

Line 357: hz_merge_dictionary d

353: Delete from fii_collectors
354: where party_id in
355: (select from_entity_id
356: from hz_merge_party_history m,
357: hz_merge_dictionary d
358: where m.merge_dict_id = d.merge_dict_id
359: and d.entity_name = 'HZ_PARTIES'
360: and batch_party_id > l_max_batch_party_id);
361:

Line 370: hz_merge_dictionary d

366:
367: select nvl(max(batch_party_id), -1)
368: into l_max_batch_party_id
369: from hz_merge_party_history m,
370: hz_merge_dictionary d
371: where m.merge_dict_id = d.merge_dict_id
372: and d.entity_name = 'HZ_PARTIES';
373:
374: