APPS.HZ_DUP_PVT dependencies on HZ_DUP_BATCH

Line 79: HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB

75: count(*) over (partition by ca.party_id) as cnt,
76: ca.last_update_date
77: from
78: HZ_CUST_ACCOUNTS CA,HZ_PARTIES PARTY, HZ_DUP_SETS DS,
79: HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB
80: WHERE CA.PARTY_ID =DSP.DUP_PARTY_ID
81: AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID
82: AND DS.DUP_SET_ID = DSP.DUP_SET_ID
83: AND CA.PARTY_ID = PARTY.PARTY_ID

Line 102: HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB

98: ps.party_id party_id, party.party_name party_name,
99: count(*) over (partition by ps.party_id) as cnt,
100: ps.last_update_date
101: from HZ_PARTY_SITES PS,HZ_PARTIES PARTY,
102: HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB
103: WHERE PS.PARTY_ID =DSP.DUP_PARTY_ID
104: AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID
105: AND DS.DUP_SET_ID = DSP.DUP_SET_ID
106: AND PS.PARTY_ID = PARTY.PARTY_ID

Line 126: HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB

122: party.party_name party_name,
123: count(*) over (partition by party.party_id) as cnt,
124: party.last_update_date
125: from HZ_RELATIONSHIPS R,HZ_PARTIES PARTY, HZ_DUP_SETS DS,
126: HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB
127: WHERE PARTY.PARTY_ID =DSP.DUP_PARTY_ID
128: AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID
129: AND DS.DUP_SET_ID = DSP.DUP_SET_ID
130: AND R.OBJECT_ID = PARTY.PARTY_ID

Line 639: HZ_DUP_BATCH_PKG.Insert_Row(

635: END IF;
636: END LOOP;
637: END IF;
638:
639: HZ_DUP_BATCH_PKG.Insert_Row(
640: px_dup_batch_id => l_dup_batch_id
641: ,p_dup_batch_name => p_dup_batch_rec.dup_batch_name
642: ,p_match_rule_id => p_dup_batch_rec.match_rule_id
643: ,p_application_id => p_dup_batch_rec.application_id

Line 737: from HZ_DUP_BATCH

733: l_temp VARCHAR2(1);
734:
735: cursor check_dup_batch_id is
736: select 'X'
737: from HZ_DUP_BATCH
738: where dup_batch_id = p_dup_set_rec.dup_batch_id;
739:
740: BEGIN
741: