DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on CSI_I_PARTIES

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

593: (select 'Y' from CSI_T_TXN_LINE_DETAILS
594: yy where yy.INSTALL_LOCATION_ID=xx.PARTY_SITE_ID
595: ))
596:
597: or exists (select 'Y' from CSI_I_PARTIES xx where xx.PARTY_ID = temp.party_id
598: )
599:
600: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SHIP_TO_CONTACT_ID = temp.party_id
601: )

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

653: (select 'Y' from CSI_T_TXN_LINE_DETAILS
654: yy where yy.INSTALL_LOCATION_ID=xx.PARTY_SITE_ID
655: ))
656:
657: or exists (select 'Y' from CSI_I_PARTIES xx where xx.PARTY_ID = temp.party_id
658: )
659:
660: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SHIP_TO_CONTACT_ID = temp.party_id
661: )