APPS.HZ_PURGE_GEN dependencies on JTF_TASK_PHONES

Line 2408: (select 'Y' from JTF_TASK_PHONES

2404: or exists (select 'Y' from HZ_CONTACT_POINTS
2405: xx where xx.OWNER_TABLE_ID = temp.party_id
2406: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
2407: and exists
2408: (select 'Y' from JTF_TASK_PHONES
2409: yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
2410: ))
2411: or exists (select 'Y' from HZ_PARTY_SITES
2412: xx where xx.PARTY_ID = temp.party_id

Line 2419: (select 'Y' from JTF_TASK_PHONES zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))

2415: (select 'Y' from HZ_CONTACT_POINTS
2416: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
2417: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
2418: and exists
2419: (select 'Y' from JTF_TASK_PHONES zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
2420:
2421: or exists (select 'Y' from HZ_PARTY_SITES
2422: xx where xx.PARTY_ID = temp.party_id
2423: and (nvl(STATUS, 'A') in ('A','I'))

Line 2602: (select 'Y' from JTF_TASK_PHONES

2598: or exists (select 'Y' from HZ_CONTACT_POINTS
2599: xx where xx.OWNER_TABLE_ID = temp.party_id
2600: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
2601: and exists
2602: (select 'Y' from JTF_TASK_PHONES
2603: yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
2604: ))
2605: or exists (select 'Y' from HZ_PARTY_SITES
2606: xx where xx.PARTY_ID = temp.party_id

Line 2613: (select 'Y' from JTF_TASK_PHONES zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))

2609: (select 'Y' from HZ_CONTACT_POINTS
2610: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
2611: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
2612: and exists
2613: (select 'Y' from JTF_TASK_PHONES zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
2614:
2615: or exists (select 'Y' from HZ_PARTY_SITES
2616: xx where xx.PARTY_ID = temp.party_id
2617: and (nvl(STATUS, 'A') in ('A','I'))