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 2721: (SELECT 'XYZ' FROM pa_lookups WHERE lookup_type = c_lookup_type AND lookup_code = c_lookup_code);

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

Line 6225: FROM pa_lookups

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

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

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

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

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

Line 14074: FROM pa_lookups

14070: l_data VARCHAR2(2000);
14071:
14072: CURSOR c_get_valid_lookup_code(c_change_reason_code VARCHAR2) IS
14073: SELECT lookup_code
14074: FROM pa_lookups
14075: WHERE lookup_type = 'CANDIDATE_STS_CHANGE_REASON'
14076: AND lookup_code = c_change_reason_code;
14077:
14078: CURSOR c_get_candidate_details(c_candidate_id NUMBER) IS