APPS.HZ_PURGE_GEN dependencies on AS_ACCESSES_ALL

Line 1178: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.CUSTOMER_ID = temp.party_id

1174:
1175: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CONTACT_PARTY_ID = temp.party_id
1176: )
1177:
1178: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.CUSTOMER_ID = temp.party_id
1179: )
1180:
1181: or exists (select 'Y' from HZ_PARTY_SITES
1182: xx where xx.PARTY_ID = temp.party_id

Line 1185: (select 'Y' from AS_ACCESSES_ALL

1181: or exists (select 'Y' from HZ_PARTY_SITES
1182: xx where xx.PARTY_ID = temp.party_id
1183: and (nvl(STATUS, 'A') in ('A','I'))
1184: and exists
1185: (select 'Y' from AS_ACCESSES_ALL
1186: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1187: ))
1188:
1189: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CUSTOMER_ID = temp.party_id

Line 1189: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CUSTOMER_ID = temp.party_id

1185: (select 'Y' from AS_ACCESSES_ALL
1186: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1187: ))
1188:
1189: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CUSTOMER_ID = temp.party_id
1190: )
1191:
1192: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CONT_PARTY_ID = temp.party_id
1193: )

Line 1192: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CONT_PARTY_ID = temp.party_id

1188:
1189: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CUSTOMER_ID = temp.party_id
1190: )
1191:
1192: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CONT_PARTY_ID = temp.party_id
1193: )
1194:
1195: or exists (select 'Y' from AS_INTERESTS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1196: )

Line 1250: (select 'Y' from AS_ACCESSES_ALL

1246: or exists (select 'Y' from HZ_PARTY_SITES
1247: xx where xx.PARTY_ID = temp.party_id
1248: and (nvl(STATUS, 'A') in ('A','I'))
1249: and exists
1250: (select 'Y' from AS_ACCESSES_ALL
1251: yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
1252: ))
1253:
1254: or exists (select 'Y' from AS_SALES_LEADS xx where xx.CUSTOMER_ID = temp.party_id

Line 1497: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.CUSTOMER_ID = temp.party_id

1493:
1494: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CONTACT_PARTY_ID = temp.party_id
1495: )
1496:
1497: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.CUSTOMER_ID = temp.party_id
1498: )
1499:
1500: or exists (select 'Y' from HZ_PARTY_SITES
1501: xx where xx.PARTY_ID = temp.party_id

Line 1504: (select 'Y' from AS_ACCESSES_ALL

1500: or exists (select 'Y' from HZ_PARTY_SITES
1501: xx where xx.PARTY_ID = temp.party_id
1502: and (nvl(STATUS, 'A') in ('A','I'))
1503: and exists
1504: (select 'Y' from AS_ACCESSES_ALL
1505: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1506: ))
1507:
1508: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CUSTOMER_ID = temp.party_id

Line 1508: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CUSTOMER_ID = temp.party_id

1504: (select 'Y' from AS_ACCESSES_ALL
1505: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1506: ))
1507:
1508: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CUSTOMER_ID = temp.party_id
1509: )
1510:
1511: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CONT_PARTY_ID = temp.party_id
1512: )

Line 1511: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CONT_PARTY_ID = temp.party_id

1507:
1508: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CUSTOMER_ID = temp.party_id
1509: )
1510:
1511: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CONT_PARTY_ID = temp.party_id
1512: )
1513:
1514: or exists (select 'Y' from AS_INTERESTS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1515: )

Line 1569: (select 'Y' from AS_ACCESSES_ALL

1565: or exists (select 'Y' from HZ_PARTY_SITES
1566: xx where xx.PARTY_ID = temp.party_id
1567: and (nvl(STATUS, 'A') in ('A','I'))
1568: and exists
1569: (select 'Y' from AS_ACCESSES_ALL
1570: yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
1571: ))
1572:
1573: or exists (select 'Y' from AS_SALES_LEADS xx where xx.CUSTOMER_ID = temp.party_id