DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on JTF_UM_APPROVERS

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

2416: (select 'Y' from JTF_RS_RESOURCE_EXTNS
2417: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
2418: and category = 'PARTNER'))
2419:
2420: or exists (select 'Y' from JTF_UM_APPROVERS xx where xx.ORG_PARTY_ID = temp.party_id
2421: and (ROWNUM < 2))
2422:
2423: or exists (select 'Y' from HZ_PARTY_SITES
2424: xx where xx.PARTY_ID = temp.party_id

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

2602: (select 'Y' from JTF_RS_RESOURCE_EXTNS
2603: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
2604: and category = 'PARTNER'))
2605:
2606: or exists (select 'Y' from JTF_UM_APPROVERS xx where xx.ORG_PARTY_ID = temp.party_id
2607: and (ROWNUM < 2))
2608:
2609: or exists (select 'Y' from HZ_PARTY_SITES
2610: xx where xx.PARTY_ID = temp.party_id