APPS.HZ_PURGE_GEN dependencies on CSI_T_TXN_LINE_DETAILS

Line 744: (select 'Y' from CSI_T_TXN_LINE_DETAILS

740: or exists (select 'Y' from HZ_PARTY_SITES
741: xx where xx.PARTY_ID = temp.party_id
742: and (nvl(STATUS, 'A') in ('A','I'))
743: and exists
744: (select 'Y' from CSI_T_TXN_LINE_DETAILS
745: yy where yy.LOCATION_ID=xx.PARTY_SITE_ID
746: ))
747:
748: or exists (select 'Y' from HZ_PARTY_SITES

Line 752: (select 'Y' from CSI_T_TXN_LINE_DETAILS

748: or exists (select 'Y' from HZ_PARTY_SITES
749: xx where xx.PARTY_ID = temp.party_id
750: and (nvl(STATUS, 'A') in ('A','I'))
751: and exists
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

Line 804: (select 'Y' from CSI_T_TXN_LINE_DETAILS

800: or exists (select 'Y' from HZ_PARTY_SITES
801: xx where xx.PARTY_ID = temp.party_id
802: and (nvl(STATUS, 'A') in ('A','I'))
803: and exists
804: (select 'Y' from CSI_T_TXN_LINE_DETAILS
805: yy where yy.LOCATION_ID=xx.PARTY_SITE_ID
806: ))
807:
808: or exists (select 'Y' from HZ_PARTY_SITES

Line 812: (select 'Y' from CSI_T_TXN_LINE_DETAILS

808: or exists (select 'Y' from HZ_PARTY_SITES
809: xx where xx.PARTY_ID = temp.party_id
810: and (nvl(STATUS, 'A') in ('A','I'))
811: and exists
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