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 121: from hz_dup_batch db, hz_dup_sets ds

117: AND nvl(MERGE_FLAG,'Y')<>'N';
118:
119: cursor sugg_request_exist_csr is
120: select count(*)
121: from hz_dup_batch db, hz_dup_sets ds
122: where db.dup_batch_id = ds.dup_batch_id
123: and db.match_rule_id = -1
124: and db.dup_batch_name like 'SUGG:%'
125: and ds.dup_set_id = p_dup_set_id;

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

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

Line 4456: hz_dup_sets ds, hz_dup_set_parties dsp, hz_dup_batch db

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