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 2749: FROM pa_country_v

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

Line 2754: FROM pa_country_v

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

Line 6265: FROM pa_country_v

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

Line 6270: FROM pa_country_v

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

Line 8044: FROM PA_COUNTRY_V

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

Line 8049: FROM PA_COUNTRY_V

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