APPS.HZ_PURGE_GEN dependencies on CS_CHG_SUB_RESTRICTIONS

Line 5256: --CS_CHG_SUB_RESTRICTIONS;VALUE_OBJECT_ID

5252: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5253: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx
5254: );
5255: end if;
5256: --CS_CHG_SUB_RESTRICTIONS;VALUE_OBJECT_ID
5257: appid:=170;
5258: if(regid_proc = true) then
5259: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5260:

Line 5261: temp.party_id in (select /*+ parallel(xx)*/ xx.VALUE_OBJECT_ID from CS_CHG_SUB_RESTRICTIONS xx

5257: appid:=170;
5258: if(regid_proc = true) then
5259: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5260:
5261: temp.party_id in (select /*+ parallel(xx)*/ xx.VALUE_OBJECT_ID from CS_CHG_SUB_RESTRICTIONS xx
5262: );
5263: else
5264: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5265: temp.party_id in (select /*+ parallel(xx)*/ xx.VALUE_OBJECT_ID from CS_CHG_SUB_RESTRICTIONS xx

Line 5265: temp.party_id in (select /*+ parallel(xx)*/ xx.VALUE_OBJECT_ID from CS_CHG_SUB_RESTRICTIONS xx

5261: temp.party_id in (select /*+ parallel(xx)*/ xx.VALUE_OBJECT_ID from CS_CHG_SUB_RESTRICTIONS xx
5262: );
5263: else
5264: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5265: temp.party_id in (select /*+ parallel(xx)*/ xx.VALUE_OBJECT_ID from CS_CHG_SUB_RESTRICTIONS xx
5266: );
5267: end if;
5268: --CS_INCIDENTS_ALL_B;BILL_TO_CONTACT_ID
5269: appid:=170;