APPS.HZ_PURGE_GEN dependencies on AS_ACCESSES_ALL

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

1071:
1072: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CONTACT_PARTY_ID = temp.party_id
1073: )
1074:
1075: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.CUSTOMER_ID = temp.party_id
1076: )
1077:
1078: or exists (select 'Y' from HZ_PARTY_SITES
1079: xx where xx.PARTY_ID = temp.party_id

Line 1082: (select 'Y' from AS_ACCESSES_ALL

1078: or exists (select 'Y' from HZ_PARTY_SITES
1079: xx where xx.PARTY_ID = temp.party_id
1080: and (nvl(STATUS, 'A') in ('A','I'))
1081: and exists
1082: (select 'Y' from AS_ACCESSES_ALL
1083: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1084: ))
1085:
1086: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CUSTOMER_ID = temp.party_id

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

1082: (select 'Y' from AS_ACCESSES_ALL
1083: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1084: ))
1085:
1086: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CUSTOMER_ID = temp.party_id
1087: )
1088:
1089: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CONT_PARTY_ID = temp.party_id
1090: )

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

1085:
1086: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CUSTOMER_ID = temp.party_id
1087: )
1088:
1089: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CONT_PARTY_ID = temp.party_id
1090: )
1091:
1092: or exists (select 'Y' from AS_INTERESTS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1093: )

Line 1147: (select 'Y' from AS_ACCESSES_ALL

1143: or exists (select 'Y' from HZ_PARTY_SITES
1144: xx where xx.PARTY_ID = temp.party_id
1145: and (nvl(STATUS, 'A') in ('A','I'))
1146: and exists
1147: (select 'Y' from AS_ACCESSES_ALL
1148: yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
1149: ))
1150:
1151: or exists (select 'Y' from AS_SALES_LEADS xx where xx.CUSTOMER_ID = temp.party_id

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

1390:
1391: or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CONTACT_PARTY_ID = temp.party_id
1392: )
1393:
1394: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.CUSTOMER_ID = temp.party_id
1395: )
1396:
1397: or exists (select 'Y' from HZ_PARTY_SITES
1398: xx where xx.PARTY_ID = temp.party_id

Line 1401: (select 'Y' from AS_ACCESSES_ALL

1397: or exists (select 'Y' from HZ_PARTY_SITES
1398: xx where xx.PARTY_ID = temp.party_id
1399: and (nvl(STATUS, 'A') in ('A','I'))
1400: and exists
1401: (select 'Y' from AS_ACCESSES_ALL
1402: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1403: ))
1404:
1405: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CUSTOMER_ID = temp.party_id

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

1401: (select 'Y' from AS_ACCESSES_ALL
1402: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1403: ))
1404:
1405: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CUSTOMER_ID = temp.party_id
1406: )
1407:
1408: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CONT_PARTY_ID = temp.party_id
1409: )

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

1404:
1405: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CUSTOMER_ID = temp.party_id
1406: )
1407:
1408: or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CONT_PARTY_ID = temp.party_id
1409: )
1410:
1411: or exists (select 'Y' from AS_INTERESTS_ALL xx where xx.CUSTOMER_ID = temp.party_id
1412: )

Line 1466: (select 'Y' from AS_ACCESSES_ALL

1462: or exists (select 'Y' from HZ_PARTY_SITES
1463: xx where xx.PARTY_ID = temp.party_id
1464: and (nvl(STATUS, 'A') in ('A','I'))
1465: and exists
1466: (select 'Y' from AS_ACCESSES_ALL
1467: yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
1468: ))
1469:
1470: or exists (select 'Y' from AS_SALES_LEADS xx where xx.CUSTOMER_ID = temp.party_id