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 2744: FROM pa_locations

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

Line 6260: FROM pa_locations

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

Line 8441: FROM PA_LOCATIONS

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