DBA Data[Home] [Help]

APPS.AHL_FMP_COMMON_PVT dependencies on FND_TERRITORIES_VL

Line 917: FROM FND_TERRITORIES_VL

913:
914: CURSOR get_rec_from_value ( c_country_name VARCHAR2 )
915: IS
916: SELECT DISTINCT territory_code
917: FROM FND_TERRITORIES_VL
918: WHERE territory_short_name = c_country_name;
919:
920: CURSOR get_rec_from_id ( c_country_code VARCHAR2 )
921: IS

Line 923: FROM FND_TERRITORIES_VL

919:
920: CURSOR get_rec_from_id ( c_country_code VARCHAR2 )
921: IS
922: SELECT DISTINCT territory_code
923: FROM FND_TERRITORIES_VL
924: WHERE territory_code = c_country_code;
925:
926: BEGIN
927: x_return_status := FND_API.G_RET_STS_SUCCESS;