APPS.HZ_PURGE_GEN dependencies on HZ_PARTY_USG_ASSIGNMENTS

Line 3548: --HZ_PARTY_USG_ASSIGNMENTS;PARTY_ID

3544: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3545: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from QA_RESULTS xx
3546: );
3547: end if;
3548: --HZ_PARTY_USG_ASSIGNMENTS;PARTY_ID
3549: appid:=177;
3550: if(regid_proc = true) then
3551: insert into hz_application_trans_gt(app_id,party_id) select 177, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 177 and appl.party_id=temp.party_id) and
3552:

Line 3558: in (select /*+ parallel(yy)*/ yy.PARTY_ID from HZ_PARTY_USG_ASSIGNMENTS

3554: xx
3555: where (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
3556: AND directional_flag = 'F')
3557: and xx.RELATIONSHIP_ID
3558: in (select /*+ parallel(yy)*/ yy.PARTY_ID from HZ_PARTY_USG_ASSIGNMENTS
3559: yy
3560: ))
3561: or temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_RELATIONSHIPS
3562: xx

Line 3566: in (select /*+ parallel(yy)*/ yy.PARTY_ID from HZ_PARTY_USG_ASSIGNMENTS

3562: xx
3563: where (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
3564: AND directional_flag = 'F')
3565: and xx.RELATIONSHIP_ID
3566: in (select /*+ parallel(yy)*/ yy.PARTY_ID from HZ_PARTY_USG_ASSIGNMENTS
3567: yy
3568: ))
3569: or temp.party_id in (select /*+ parallel (xx)*/ xx.SUBJECT_ID from HZ_RELATIONSHIPS
3570: xx

Line 3574: in (select /*+ parallel(yy)*/ yy.PARTY_ID from HZ_PARTY_USG_ASSIGNMENTS

3570: xx
3571: where (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
3572: AND directional_flag = 'F')
3573: and xx.RELATIONSHIP_ID
3574: in (select /*+ parallel(yy)*/ yy.PARTY_ID from HZ_PARTY_USG_ASSIGNMENTS
3575: yy
3576: ));
3577: else
3578: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 3584: in (select /*+ parallel(yy)*/ yy.PARTY_ID from HZ_PARTY_USG_ASSIGNMENTS

3580: xx
3581: where (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
3582: AND directional_flag = 'F')
3583: and xx.RELATIONSHIP_ID
3584: in (select /*+ parallel(yy)*/ yy.PARTY_ID from HZ_PARTY_USG_ASSIGNMENTS
3585: yy
3586: ))
3587: or temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_RELATIONSHIPS
3588: xx

Line 3592: in (select /*+ parallel(yy)*/ yy.PARTY_ID from HZ_PARTY_USG_ASSIGNMENTS

3588: xx
3589: where (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
3590: AND directional_flag = 'F')
3591: and xx.RELATIONSHIP_ID
3592: in (select /*+ parallel(yy)*/ yy.PARTY_ID from HZ_PARTY_USG_ASSIGNMENTS
3593: yy
3594: ))
3595: or temp.party_id in (select /*+ parallel (xx)*/ xx.SUBJECT_ID from HZ_RELATIONSHIPS
3596: xx

Line 3600: in (select /*+ parallel(yy)*/ yy.PARTY_ID from HZ_PARTY_USG_ASSIGNMENTS

3596: xx
3597: where (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES' AND object_table_name = 'HZ_PARTIES'
3598: AND directional_flag = 'F')
3599: and xx.RELATIONSHIP_ID
3600: in (select /*+ parallel(yy)*/ yy.PARTY_ID from HZ_PARTY_USG_ASSIGNMENTS
3601: yy
3602: ));
3603: end if;
3604: --POS_PARTY_SITE_UDA_V;PARTY_SITE_ID