DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on CSI_I_PARTIES

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

752: (select 'Y' from CSI_T_TXN_LINE_DETAILS
753: yy where yy.INSTALL_LOCATION_ID=xx.PARTY_SITE_ID
754: ))
755:
756: or exists (select 'Y' from CSI_I_PARTIES xx where xx.PARTY_ID = temp.party_id
757: )
758:
759: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SHIP_TO_CONTACT_ID = temp.party_id
760: )

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

812: (select 'Y' from CSI_T_TXN_LINE_DETAILS
813: yy where yy.INSTALL_LOCATION_ID=xx.PARTY_SITE_ID
814: ))
815:
816: or exists (select 'Y' from CSI_I_PARTIES xx where xx.PARTY_ID = temp.party_id
817: )
818:
819: or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SHIP_TO_CONTACT_ID = temp.party_id
820: )