APPS.AS_VALIDATE_SETUP dependencies on AS_TERRITORIES_ALL

Line 1061: FROM AS_TERR_TYPE_QUALIFIERS C, AS_TERRITORIES_ALL A

1057: Write_log(l_module, ' ');
1058: Write_log(l_module, '**** Checking the setup for Territory module ****');
1059: BEGIN
1060: SELECT count(*) INTO l_count
1061: FROM AS_TERR_TYPE_QUALIFIERS C, AS_TERRITORIES_ALL A
1062: WHERE A.TERRITORY_TYPE_ID = C.TERRITORY_TYPE_ID
1063: AND C.seeded_qualifier_id not in (
1064: select B.seeded_qualifier_id
1065: from AS_TERRITORY_VALUES_ALL B

Line 1076: ||'): invalid records found in AS_TERRITORIES_ALL');

1072: l_err_num := l_err_num+1;
1073: l_err_total := l_err_total+1;
1074: Write_log(l_module, ' ');
1075: Write_log(l_module, 'Error('||to_char(l_err_total)
1076: ||'): invalid records found in AS_TERRITORIES_ALL');
1077: Write_log(l_module, '(The record is invalid if the Qualifier has no'
1078: ||' Value defined in AS_TERRITORY_VALUES_ALL.)');
1079: ELSE
1080: Write_log(l_module, ' ');