APPS.HZ_MERGE_DUP_PVT dependencies on HZ_DUP_BATCH

Line 107: from hz_dup_batch db, hz_dup_sets ds

103: AND dup_set_id = p_dup_set_id;
104:
105: cursor get_automerge_flag_csr is
106: select nvl(db.automerge_flag,'N')
107: from hz_dup_batch db, hz_dup_sets ds
108: where db.dup_batch_id = ds.dup_batch_id
109: and ds.dup_set_id = p_dup_set_id
110: and rownum=1;
111:

Line 122: from hz_dup_batch db, hz_dup_sets ds

118: ORDER BY decode(dup_party_id,cp_winner_party_id,2,1);
119:
120: cursor sugg_request_exist_csr is
121: select count(*)
122: from hz_dup_batch db, hz_dup_sets ds
123: where db.dup_batch_id = ds.dup_batch_id
124: and db.match_rule_id = -1
125: and db.dup_batch_name like 'SUGG:%'
126: and ds.dup_set_id = p_dup_set_id;

Line 4448: from hz_parties party, hz_dup_sets ds, hz_dup_set_parties dsp, hz_dup_batch db

4444: x_msg_data OUT NOCOPY VARCHAR2 ) is
4445:
4446: cursor dset_overlap_merged_party_csr is
4447: select party.party_number,ds.object_version_number
4448: from hz_parties party, hz_dup_sets ds, hz_dup_set_parties dsp, hz_dup_batch db
4449: where party.party_id =dsp.dup_party_id
4450: and db.dup_batch_id = ds.dup_batch_id
4451: and ds.dup_set_id = dsp.dup_set_id
4452: and party.status = 'M'

Line 4458: hz_dup_sets ds, hz_dup_set_parties dsp, hz_dup_batch db

4454:
4455: cursor dset_overlap_req_party_csr is
4456: select distinct mp.batch_id,dsp.dup_party_id,ds.object_version_number
4457: from hz_merge_batch mb, hz_merge_parties mp,
4458: hz_dup_sets ds, hz_dup_set_parties dsp, hz_dup_batch db
4459: where mp.batch_id <> ds.dup_set_id
4460: and mb.batch_id = mp.batch_id
4461: and db.dup_batch_id = ds.dup_batch_id
4462: and ds.dup_set_id = dsp.dup_set_id