APPS.HZ_PURGE_GEN dependencies on IGW_PROP_PERSONS_TCA_V

Line 37: exists (select 'Y' from IGW_PROP_PERSONS_TCA_V xx where xx.PERSON_PARTY_ID = temp.party_id

33: if(regid_proc = true) then
34: insert into hz_application_trans_gt(app_id,party_id) select 8404, temp.party_id from hz_purge_gt temp where
35:
36:
37: exists (select 'Y' from IGW_PROP_PERSONS_TCA_V xx where xx.PERSON_PARTY_ID = temp.party_id
38: );
39: else
40: delete from hz_purge_gt temp where
41:

Line 43: exists (select 'Y' from IGW_PROP_PERSONS_TCA_V xx where xx.PERSON_PARTY_ID = temp.party_id

39: else
40: delete from hz_purge_gt temp where
41:
42:
43: exists (select 'Y' from IGW_PROP_PERSONS_TCA_V xx where xx.PERSON_PARTY_ID = temp.party_id
44: );
45: end if;
46:
47:

Line 2898: --IGW_PROP_PERSONS_TCA_V;ORG_PARTY_ID

2894: delete /*+ parallel(temp) */ from hz_purge_gt temp where
2895: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGW_PERSON_BIOSKETCH xx
2896: );
2897: end if;
2898: --IGW_PROP_PERSONS_TCA_V;ORG_PARTY_ID
2899: appid:=8404;
2900: if(regid_proc = true) then
2901: insert into hz_application_trans_gt(app_id,party_id) select 8404, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 8404 and appl.party_id=temp.party_id) and
2902:

Line 2903: temp.party_id in (select /*+ parallel(xx)*/ xx.ORG_PARTY_ID from IGW_PROP_PERSONS_TCA_V xx

2899: appid:=8404;
2900: if(regid_proc = true) then
2901: insert into hz_application_trans_gt(app_id,party_id) select 8404, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 8404 and appl.party_id=temp.party_id) and
2902:
2903: temp.party_id in (select /*+ parallel(xx)*/ xx.ORG_PARTY_ID from IGW_PROP_PERSONS_TCA_V xx
2904: );
2905: else
2906: delete /*+ parallel(temp) */ from hz_purge_gt temp where
2907: temp.party_id in (select /*+ parallel(xx)*/ xx.ORG_PARTY_ID from IGW_PROP_PERSONS_TCA_V xx

Line 2907: temp.party_id in (select /*+ parallel(xx)*/ xx.ORG_PARTY_ID from IGW_PROP_PERSONS_TCA_V xx

2903: temp.party_id in (select /*+ parallel(xx)*/ xx.ORG_PARTY_ID from IGW_PROP_PERSONS_TCA_V xx
2904: );
2905: else
2906: delete /*+ parallel(temp) */ from hz_purge_gt temp where
2907: temp.party_id in (select /*+ parallel(xx)*/ xx.ORG_PARTY_ID from IGW_PROP_PERSONS_TCA_V xx
2908: );
2909: end if;
2910: --IGW_PROP_PERSON_SUPPORT;LOCATION_PARTY_ID
2911: appid:=8404;