APPS.HZ_PURGE_GEN dependencies on CSI_T_TXN_LINE_DETAILS

Line 585: (select 'Y' from CSI_T_TXN_LINE_DETAILS

581: or exists (select 'Y' from HZ_PARTY_SITES
582: xx where xx.PARTY_ID = temp.party_id
583: and (nvl(STATUS, 'A') in ('A','I'))
584: and exists
585: (select 'Y' from CSI_T_TXN_LINE_DETAILS
586: yy where yy.LOCATION_ID=xx.PARTY_SITE_ID
587: ))
588:
589: or exists (select 'Y' from HZ_PARTY_SITES

Line 593: (select 'Y' from CSI_T_TXN_LINE_DETAILS

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

Line 645: (select 'Y' from CSI_T_TXN_LINE_DETAILS

641: or exists (select 'Y' from HZ_PARTY_SITES
642: xx where xx.PARTY_ID = temp.party_id
643: and (nvl(STATUS, 'A') in ('A','I'))
644: and exists
645: (select 'Y' from CSI_T_TXN_LINE_DETAILS
646: yy where yy.LOCATION_ID=xx.PARTY_SITE_ID
647: ))
648:
649: or exists (select 'Y' from HZ_PARTY_SITES

Line 653: (select 'Y' from CSI_T_TXN_LINE_DETAILS

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