DBA Data[Home] [Help]

APPS.POS_VALIDATE_ASN dependencies on FND_TERRITORIES_VL

Line 117: FROM fnd_territories_vl

113: BEGIN
114:
115: SELECT COUNT(*)
116: INTO P_COUNT
117: FROM fnd_territories_vl
118: WHERE territory_short_name = P_TERRITORY_SHORT_NAME;
119:
120: IF (P_COUNT = 1) THEN
121: SELECT territory_code

Line 123: FROM fnd_territories_vl

119:
120: IF (P_COUNT = 1) THEN
121: SELECT territory_code
122: INTO P_TERRITORY_CODE
123: FROM fnd_territories_vl
124: WHERE territory_short_name = P_TERRITORY_SHORT_NAME;
125: END IF;
126:
127: END country_of_origin;