APPS.HZ_PURGE_GEN dependencies on CSI_ITEM_INSTANCES

Line 737: exists (select 'Y' from CSI_ITEM_INSTANCES xx where xx.OWNER_PARTY_ID = temp.party_id

733: if(regid_proc = true) then
734: insert into hz_application_trans_gt(app_id,party_id) select 542, temp.party_id from hz_purge_gt temp where
735:
736:
737: exists (select 'Y' from CSI_ITEM_INSTANCES xx where xx.OWNER_PARTY_ID = temp.party_id
738: )
739:
740: or exists (select 'Y' from HZ_PARTY_SITES
741: xx where xx.PARTY_ID = temp.party_id

Line 797: exists (select 'Y' from CSI_ITEM_INSTANCES xx where xx.OWNER_PARTY_ID = temp.party_id

793: else
794: delete from hz_purge_gt temp where
795:
796:
797: exists (select 'Y' from CSI_ITEM_INSTANCES xx where xx.OWNER_PARTY_ID = temp.party_id
798: )
799:
800: or exists (select 'Y' from HZ_PARTY_SITES
801: xx where xx.PARTY_ID = temp.party_id

Line 3634: --CSI_ITEM_INSTANCES;LOCATION_ID

3630: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3631: temp.party_id in (select /*+ parallel(xx)*/ xx.CONTACT_PARTY_ID from PRP_PROPOSALS xx
3632: );
3633: end if;
3634: --CSI_ITEM_INSTANCES;LOCATION_ID
3635: appid:=542;
3636: if(regid_proc = true) then
3637: insert into hz_application_trans_gt(app_id,party_id) select 542, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 542 and appl.party_id=temp.party_id) and
3638:

Line 3643: in (select /*+ parallel(yy)*/ yy.LOCATION_ID from CSI_ITEM_INSTANCES

3639: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3640: xx
3641: where (nvl(STATUS, 'A') in ('A','I'))
3642: and xx.PARTY_SITE_ID
3643: in (select /*+ parallel(yy)*/ yy.LOCATION_ID from CSI_ITEM_INSTANCES
3644: yy
3645: ));
3646: else
3647: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 3652: in (select /*+ parallel(yy)*/ yy.LOCATION_ID from CSI_ITEM_INSTANCES

3648: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3649: xx
3650: where (nvl(STATUS, 'A') in ('A','I'))
3651: and xx.PARTY_SITE_ID
3652: in (select /*+ parallel(yy)*/ yy.LOCATION_ID from CSI_ITEM_INSTANCES
3653: yy
3654: ));
3655: end if;
3656: --CSI_ITEM_INSTANCES;INSTALL_LOCATION_ID

Line 3656: --CSI_ITEM_INSTANCES;INSTALL_LOCATION_ID

3652: in (select /*+ parallel(yy)*/ yy.LOCATION_ID from CSI_ITEM_INSTANCES
3653: yy
3654: ));
3655: end if;
3656: --CSI_ITEM_INSTANCES;INSTALL_LOCATION_ID
3657: appid:=542;
3658: if(regid_proc = true) then
3659: insert into hz_application_trans_gt(app_id,party_id) select 542, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 542 and appl.party_id=temp.party_id) and
3660:

Line 3665: in (select /*+ parallel(yy)*/ yy.INSTALL_LOCATION_ID from CSI_ITEM_INSTANCES

3661: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3662: xx
3663: where (nvl(STATUS, 'A') in ('A','I'))
3664: and xx.PARTY_SITE_ID
3665: in (select /*+ parallel(yy)*/ yy.INSTALL_LOCATION_ID from CSI_ITEM_INSTANCES
3666: yy
3667: ));
3668: else
3669: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 3674: in (select /*+ parallel(yy)*/ yy.INSTALL_LOCATION_ID from CSI_ITEM_INSTANCES

3670: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3671: xx
3672: where (nvl(STATUS, 'A') in ('A','I'))
3673: and xx.PARTY_SITE_ID
3674: in (select /*+ parallel(yy)*/ yy.INSTALL_LOCATION_ID from CSI_ITEM_INSTANCES
3675: yy
3676: ));
3677: end if;
3678: --CSI_T_TXN_SYSTEMS;INSTALL_SITE_USE_ID