APPS.HZ_PURGE_GEN dependencies on CS_INCIDENTS_AUDIT_B

Line 5132: --CS_INCIDENTS_AUDIT_B;SITE_ID

5128: in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_ALL_B
5129: yy
5130: ));
5131: end if;
5132: --CS_INCIDENTS_AUDIT_B;SITE_ID
5133: appid:=170;
5134: if(regid_proc = true) then
5135: 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
5136:

Line 5141: in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_AUDIT_B

5137: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5138: xx
5139: where (nvl(STATUS, 'A') in ('A','I'))
5140: and xx.PARTY_SITE_ID
5141: in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_AUDIT_B
5142: yy
5143: ));
5144: else
5145: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 5150: in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_AUDIT_B

5146: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
5147: xx
5148: where (nvl(STATUS, 'A') in ('A','I'))
5149: and xx.PARTY_SITE_ID
5150: in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_AUDIT_B
5151: yy
5152: ));
5153: end if;
5154: --CS_INCIDENTS_ALL_B;BILL_TO_SITE_ID

Line 5220: --CS_INCIDENTS_AUDIT_B;BILL_TO_CONTACT_ID

5216: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_ID from CS_INCIDENTS_ALL_B
5217: yy
5218: ));
5219: end if;
5220: --CS_INCIDENTS_AUDIT_B;BILL_TO_CONTACT_ID
5221: appid:=170;
5222: if(regid_proc = true) then
5223: 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
5224:

Line 5225: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_AUDIT_B xx

5221: appid:=170;
5222: if(regid_proc = true) then
5223: 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
5224:
5225: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_AUDIT_B xx
5226: );
5227: else
5228: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5229: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_AUDIT_B xx

Line 5229: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_AUDIT_B xx

5225: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_AUDIT_B xx
5226: );
5227: else
5228: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5229: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_AUDIT_B xx
5230: );
5231: end if;
5232: --CS_INCIDENTS_ALL_B;BILL_TO_PARTY_ID
5233: appid:=170;