APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_COUNTRY_V

Line 448: FROM pa_country_v

444: WHERE location_id = c_location_id;
445:
446: CURSOR c_derive_country_code(c_country_name IN VARCHAR2) IS
447: SELECT country_code
448: FROM pa_country_v
449: WHERE name = c_country_name;
450:
451: CURSOR c_derive_country_name(c_country_code IN VARCHAR2) IS
452: SELECT name

Line 453: FROM pa_country_v

449: WHERE name = c_country_name;
450:
451: CURSOR c_derive_country_name(c_country_code IN VARCHAR2) IS
452: SELECT name
453: FROM pa_country_v
454: WHERE country_code = c_country_code;
455:
456:
457: -- This cursor is for future extension when we support creation of team role from planning resource

Line 2750: FROM pa_country_v

2746: WHERE location_id = c_location_id;
2747:
2748: CURSOR c_derive_country_code(c_country_name IN VARCHAR2) IS
2749: SELECT country_code
2750: FROM pa_country_v
2751: WHERE name = c_country_name;
2752:
2753: CURSOR c_derive_country_name(c_country_code IN VARCHAR2) IS
2754: SELECT name

Line 2755: FROM pa_country_v

2751: WHERE name = c_country_name;
2752:
2753: CURSOR c_derive_country_name(c_country_code IN VARCHAR2) IS
2754: SELECT name
2755: FROM pa_country_v
2756: WHERE country_code = c_country_code;
2757:
2758: -- 5144288, 5144369 : Added c_get_mcb_flag
2759: CURSOR c_get_mcb_flag(c_project_id NUMBER) IS

Line 6266: FROM pa_country_v

6262: WHERE location_id = c_location_id;
6263:
6264: CURSOR c_derive_country_code(c_country_name IN VARCHAR2) IS
6265: SELECT country_code
6266: FROM pa_country_v
6267: WHERE name = c_country_name;
6268:
6269: CURSOR c_derive_country_name(c_country_code IN VARCHAR2) IS
6270: SELECT name

Line 6271: FROM pa_country_v

6267: WHERE name = c_country_name;
6268:
6269: CURSOR c_derive_country_name(c_country_code IN VARCHAR2) IS
6270: SELECT name
6271: FROM pa_country_v
6272: WHERE country_code = c_country_code;
6273:
6274:
6275: -- This cursor is for future extension when we support creation of team role from planning resource

Line 8046: FROM PA_COUNTRY_V

8042: (SELECT 'XYZ' FROM pa_lookups WHERE lookup_type = c_lookup_type AND lookup_code = c_lookup_code);
8043:
8044: CURSOR c_derive_country_code(c_country_name IN VARCHAR2) IS
8045: SELECT COUNTRY_CODE
8046: FROM PA_COUNTRY_V
8047: WHERE NAME = c_country_name;
8048:
8049: CURSOR c_derive_country_name(c_country_code IN VARCHAR2) IS
8050: SELECT NAME

Line 8051: FROM PA_COUNTRY_V

8047: WHERE NAME = c_country_name;
8048:
8049: CURSOR c_derive_country_name(c_country_code IN VARCHAR2) IS
8050: SELECT NAME
8051: FROM PA_COUNTRY_V
8052: WHERE COUNTRY_CODE = c_country_code;
8053:
8054: -- 5144288, 5144369 : Added c_get_mcb_flag
8055: CURSOR c_get_mcb_flag(c_project_id NUMBER) IS