APPS.HZ_PARTY_MERGE dependencies on HZ_DUP_BATCH

Line 388: HZ_DUP_BATCH dbat,

384:
385: cursor c_request_type(cp_batch_id NUMBER) is
386: select dbat.request_type
387: from
388: HZ_DUP_BATCH dbat,
389: HZ_DUP_SETS dset,
390: HZ_MERGE_BATCH mb
391: where
392: dbat.dup_batch_id = dset.dup_batch_id

Line 694: FROM hz_dup_sets ds, hz_dup_batch db

690:
691: g_automerge_flag := 'N';
692: BEGIN
693: SELECT NVL(automerge_flag, 'N') INTO g_automerge_flag
694: FROM hz_dup_sets ds, hz_dup_batch db
695: WHERE ds.dup_set_id = l_batch_id
696: AND db.dup_batch_id = ds.dup_batch_id
697: AND rownum = 1;
698: EXCEPTION