APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_LOCATIONS

Line 443: FROM pa_locations

439:
440:
441: CURSOR c_get_location(c_location_id NUMBER) IS
442: SELECT country_code, region, city
443: FROM pa_locations
444: WHERE location_id = c_location_id;
445:
446: CURSOR c_derive_country_code(c_country_name IN VARCHAR2) IS
447: SELECT country_code

Line 2745: FROM pa_locations

2741: AND project_status_code = c_status_code;
2742:
2743: CURSOR c_get_location(c_location_id NUMBER) IS
2744: SELECT country_code, region, city
2745: FROM pa_locations
2746: WHERE location_id = c_location_id;
2747:
2748: CURSOR c_derive_country_code(c_country_name IN VARCHAR2) IS
2749: SELECT country_code

Line 6261: FROM pa_locations

6257: (SELECT 'XYZ' FROM pa_lookups WHERE lookup_type = c_lookup_type AND lookup_code = c_lookup_code);
6258:
6259: CURSOR c_get_location(c_location_id NUMBER) IS
6260: SELECT country_code, region, city
6261: FROM pa_locations
6262: WHERE location_id = c_location_id;
6263:
6264: CURSOR c_derive_country_code(c_country_name IN VARCHAR2) IS
6265: SELECT country_code

Line 8443: FROM PA_LOCATIONS

8439: AND ( l_asgn_db_values_rec.location_id IS NOT NULL)
8440: THEN
8441: SELECT country_code,region,city
8442: INTO l_dummy_country_code,l_dummy_state,l_dummy_city
8443: FROM PA_LOCATIONS
8444: WHERE location_id = l_asgn_db_values_rec.location_id;
8445: END IF;
8446:
8447: IF (l_asgn_rec.location_country_code <> G_PA_MISS_CHAR)