APPS.HZ_PURGE_GEN dependencies on JTF_TTY_NAMED_ACCTS

Line 2451: or exists (select 'Y' from JTF_TTY_NAMED_ACCTS xx where xx.PARTY_ID = temp.party_id

2447: (select 'Y' from JTF_RS_RESOURCE_EXTNS
2448: yy where yy.SUPPORT_SITE_ID=xx.PARTY_SITE_ID
2449: ))
2450:
2451: or exists (select 'Y' from JTF_TTY_NAMED_ACCTS xx where xx.PARTY_ID = temp.party_id
2452: );
2453: else
2454: delete from hz_purge_gt temp where
2455:

Line 2637: or exists (select 'Y' from JTF_TTY_NAMED_ACCTS xx where xx.PARTY_ID = temp.party_id

2633: (select 'Y' from JTF_RS_RESOURCE_EXTNS
2634: yy where yy.SUPPORT_SITE_ID=xx.PARTY_SITE_ID
2635: ))
2636:
2637: or exists (select 'Y' from JTF_TTY_NAMED_ACCTS xx where xx.PARTY_ID = temp.party_id
2638: );
2639: end if;
2640:
2641:

Line 4810: --JTF_TTY_NAMED_ACCTS;PARTY_SITE_ID

4806: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4807: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from JTF_FM_CONTENT_HISTORY_V xx
4808: );
4809: end if;
4810: --JTF_TTY_NAMED_ACCTS;PARTY_SITE_ID
4811: appid:=690;
4812: if(regid_proc = true) then
4813: insert into hz_application_trans_gt(app_id,party_id) select 690, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 690 and appl.party_id=temp.party_id) and
4814:

Line 4819: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from JTF_TTY_NAMED_ACCTS

4815: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4816: xx
4817: where (nvl(STATUS, 'A') in ('A','I'))
4818: and xx.PARTY_SITE_ID
4819: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from JTF_TTY_NAMED_ACCTS
4820: yy
4821: ));
4822: else
4823: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 4828: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from JTF_TTY_NAMED_ACCTS

4824: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4825: xx
4826: where (nvl(STATUS, 'A') in ('A','I'))
4827: and xx.PARTY_SITE_ID
4828: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from JTF_TTY_NAMED_ACCTS
4829: yy
4830: ));
4831: end if;
4832: --OKS_QUALIFIERS;QUALIFIER_ATTR_VALUE