APPS.HZ_PURGE_GEN dependencies on CS_INCIDENTS_AUDIT_B

Line 4912: --CS_INCIDENTS_AUDIT_B;SITE_ID

4908: in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_ALL_B
4909: yy
4910: ));
4911: end if;
4912: --CS_INCIDENTS_AUDIT_B;SITE_ID
4913: appid:=170;
4914: if(regid_proc = true) then
4915: 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
4916:

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

4917: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4918: xx
4919: where (nvl(STATUS, 'A') in ('A','I'))
4920: and xx.PARTY_SITE_ID
4921: in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_AUDIT_B
4922: yy
4923: ));
4924: else
4925: delete /*+ parallel(temp) */ from hz_purge_gt temp where

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

4926: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4927: xx
4928: where (nvl(STATUS, 'A') in ('A','I'))
4929: and xx.PARTY_SITE_ID
4930: in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_AUDIT_B
4931: yy
4932: ));
4933: end if;
4934: --CS_INCIDENTS_ALL_B;BILL_TO_SITE_ID

Line 5000: --CS_INCIDENTS_AUDIT_B;BILL_TO_CONTACT_ID

4996: in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_ID from CS_INCIDENTS_ALL_B
4997: yy
4998: ));
4999: end if;
5000: --CS_INCIDENTS_AUDIT_B;BILL_TO_CONTACT_ID
5001: appid:=170;
5002: if(regid_proc = true) then
5003: 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
5004:

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

5001: appid:=170;
5002: if(regid_proc = true) then
5003: 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
5004:
5005: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_AUDIT_B xx
5006: );
5007: else
5008: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5009: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_AUDIT_B xx

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

5005: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_AUDIT_B xx
5006: );
5007: else
5008: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5009: temp.party_id in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_AUDIT_B xx
5010: );
5011: end if;
5012: --CS_INCIDENTS_ALL_B;BILL_TO_PARTY_ID
5013: appid:=170;