APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_LOOKUPS

Line 407: FROM pa_lookups

403:
404:
405: CURSOR c_get_valid_calendar_types(c_code VARCHAR2) IS
406: SELECT lookup_code
407: FROM pa_lookups
408: WHERE lookup_type = 'CHANGE_CALENDAR_TYPE_CODE'
409: AND lookup_code = c_code
410: AND lookup_code <> 'RESOURCE';
411:

Line 438: (SELECT 'XYZ' FROM pa_lookups WHERE lookup_type = c_lookup_type AND lookup_code = c_lookup_code);

434: CURSOR c_get_lookup_exists(c_lookup_type VARCHAR2, c_lookup_code VARCHAR2) IS
435: SELECT 'Y'
436: FROM dual
437: WHERE EXISTS
438: (SELECT 'XYZ' FROM pa_lookups WHERE lookup_type = c_lookup_type AND lookup_code = c_lookup_code);
439:
440:
441: CURSOR c_get_location(c_location_id NUMBER) IS
442: SELECT country_code, region, city

Line 2722: (SELECT 'XYZ' FROM pa_lookups WHERE lookup_type = c_lookup_type AND lookup_code = c_lookup_code);

2718: CURSOR c_get_lookup_exists(c_lookup_type VARCHAR2, c_lookup_code VARCHAR2) IS
2719: SELECT 'Y'
2720: FROM dual
2721: WHERE EXISTS
2722: (SELECT 'XYZ' FROM pa_lookups WHERE lookup_type = c_lookup_type AND lookup_code = c_lookup_code);
2723:
2724: CURSOR c_get_subteam_party_id(c_requirement_id NUMBER) IS
2725: SELECT project_subteam_party_id, project_subteam_id
2726: FROM pa_project_subteam_parties

Line 6226: FROM pa_lookups

6222:
6223:
6224: CURSOR c_get_valid_calendar_types(c_code VARCHAR2) IS
6225: SELECT lookup_code
6226: FROM pa_lookups
6227: WHERE lookup_type = 'CHANGE_CALENDAR_TYPE_CODE'
6228: AND lookup_code = c_code
6229: AND lookup_code <> 'RESOURCE';
6230:

Line 6257: (SELECT 'XYZ' FROM pa_lookups WHERE lookup_type = c_lookup_type AND lookup_code = c_lookup_code);

6253: CURSOR c_get_lookup_exists(c_lookup_type VARCHAR2, c_lookup_code VARCHAR2) IS
6254: SELECT 'Y'
6255: FROM dual
6256: WHERE EXISTS
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

Line 8042: (SELECT 'XYZ' FROM pa_lookups WHERE lookup_type = c_lookup_type AND lookup_code = c_lookup_code);

8038: CURSOR c_get_lookup_exists(c_lookup_type VARCHAR2, c_lookup_code VARCHAR2) IS
8039: SELECT 'Y'
8040: FROM dual
8041: WHERE EXISTS
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

Line 14112: FROM pa_lookups

14108: l_data VARCHAR2(2000);
14109:
14110: CURSOR c_get_valid_lookup_code(c_change_reason_code VARCHAR2) IS
14111: SELECT lookup_code
14112: FROM pa_lookups
14113: WHERE lookup_type = 'CANDIDATE_STS_CHANGE_REASON'
14114: AND lookup_code = c_change_reason_code;
14115:
14116: CURSOR c_get_candidate_details(c_candidate_id NUMBER) IS