APPS.HZ_PURGE_GEN dependencies on JTF_TASK_PHONES

Line 2331: (select 'Y' from JTF_TASK_PHONES

2327: or exists (select 'Y' from HZ_CONTACT_POINTS
2328: xx where xx.OWNER_TABLE_ID = temp.party_id
2329: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
2330: and exists
2331: (select 'Y' from JTF_TASK_PHONES
2332: yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
2333: ))
2334: or exists (select 'Y' from HZ_PARTY_SITES
2335: xx where xx.PARTY_ID = temp.party_id

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

2338: (select 'Y' from HZ_CONTACT_POINTS
2339: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
2340: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
2341: and exists
2342: (select 'Y' from JTF_TASK_PHONES zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
2343:
2344: or exists (select 'Y' from HZ_PARTY_SITES
2345: xx where xx.PARTY_ID = temp.party_id
2346: and (nvl(STATUS, 'A') in ('A','I'))

Line 2517: (select 'Y' from JTF_TASK_PHONES

2513: or exists (select 'Y' from HZ_CONTACT_POINTS
2514: xx where xx.OWNER_TABLE_ID = temp.party_id
2515: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
2516: and exists
2517: (select 'Y' from JTF_TASK_PHONES
2518: yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
2519: ))
2520: or exists (select 'Y' from HZ_PARTY_SITES
2521: xx where xx.PARTY_ID = temp.party_id

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

2524: (select 'Y' from HZ_CONTACT_POINTS
2525: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
2526: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
2527: and exists
2528: (select 'Y' from JTF_TASK_PHONES zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))
2529:
2530: or exists (select 'Y' from HZ_PARTY_SITES
2531: xx where xx.PARTY_ID = temp.party_id
2532: and (nvl(STATUS, 'A') in ('A','I'))