APPS.AS_VALIDATE_SETUP dependencies on AS_TERRITORY_VALUES_ALL

Line 1065: from AS_TERRITORY_VALUES_ALL B

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
1066: where A.TERRITORY_ID =B.TERRITORY_ID);
1067: EXCEPTION
1068: WHEN OTHERS THEN
1069: l_count := 0;

Line 1078: ||' Value defined in AS_TERRITORY_VALUES_ALL.)');

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, ' ');
1081: Write_log(l_module, 'Success: no invalid qualifier found in territory records');
1082: END IF;