DBA Data[Home] [Help]

APPS.FII_PARTY_MKT_CLASS_C dependencies on HZ_MERGE_DICTIONARY

Line 269: hz_merge_dictionary d

265:
266: select nvl(max(batch_party_id), -1)
267: into l_max_batch_party_id
268: from hz_merge_party_history m,
269: hz_merge_dictionary d
270: where m.merge_dict_id = d.merge_dict_id
271: and d.entity_name = 'HZ_PARTIES';
272:
273: INSERT INTO fii_change_log

Line 429: hz_merge_dictionary d

425: Delete from fii_party_mkt_class
426: where party_id in
427: (select from_entity_id
428: from hz_merge_party_history m,
429: hz_merge_dictionary d
430: where m.merge_dict_id = d.merge_dict_id
431: and d.entity_name = 'HZ_PARTIES'
432: and batch_party_id > l_max_batch_party_id);
433:

Line 440: hz_merge_dictionary d

436:
437: select nvl(max(batch_party_id), -1)
438: into l_max_batch_party_id
439: from hz_merge_party_history m,
440: hz_merge_dictionary d
441: where m.merge_dict_id = d.merge_dict_id
442: and d.entity_name = 'HZ_PARTIES';
443:
444: INSERT INTO fii_change_log