DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on JTF_UM_APPROVERS

Line 2497: or exists (select 'Y' from JTF_UM_APPROVERS xx where xx.ORG_PARTY_ID = temp.party_id

2493: (select 'Y' from JTF_RS_RESOURCE_EXTNS
2494: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
2495: and category = 'PARTNER'))
2496:
2497: or exists (select 'Y' from JTF_UM_APPROVERS xx where xx.ORG_PARTY_ID = temp.party_id
2498: and (ROWNUM < 2))
2499:
2500: or exists (select 'Y' from HZ_PARTY_SITES
2501: xx where xx.PARTY_ID = temp.party_id

Line 2691: or exists (select 'Y' from JTF_UM_APPROVERS xx where xx.ORG_PARTY_ID = temp.party_id

2687: (select 'Y' from JTF_RS_RESOURCE_EXTNS
2688: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
2689: and category = 'PARTNER'))
2690:
2691: or exists (select 'Y' from JTF_UM_APPROVERS xx where xx.ORG_PARTY_ID = temp.party_id
2692: and (ROWNUM < 2))
2693:
2694: or exists (select 'Y' from HZ_PARTY_SITES
2695: xx where xx.PARTY_ID = temp.party_id