APPS.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on FND_LOOKUP_VALUES

Line 2423: FROM fnd_lookup_values

2419:
2420: CURSOR cur_option_name
2421: IS
2422: SELECT meaning
2423: FROM fnd_lookup_values
2424: WHERE lookup_type = 'PA_OPTIONS_SS'
2425: AND lookup_code = p_option_code
2426: AND language = userenv('LANG'); -- Bug 5643345: Added the environment language condition.
2427: -- anlee

Line 2666: FROM fnd_lookup_values

2662: THEN
2663: BEGIN
2664: SELECT meaning
2665: INTO l_field_name_meaning
2666: FROM fnd_lookup_values
2667: WHERE lookup_type = 'OVERRIDE FIELD'
2668: AND lookup_code = p_field_name;
2669: EXCEPTION
2670: WHEN NO_DATA_FOUND THEN

Line 2962: FROM fnd_lookup_values

2958: THEN
2959: BEGIN
2960: SELECT meaning
2961: INTO l_field_name_meaning
2962: FROM fnd_lookup_values
2963: WHERE lookup_type = 'OVERRIDE FIELD'
2964: AND lookup_code = p_field_name;
2965: EXCEPTION
2966: WHEN NO_DATA_FOUND THEN

Line 3235: FROM fnd_lookup_values lk1, fnd_lookup_values lk2

3231:
3232: CURSOR cur_pa_lkups
3233: IS
3234: SELECT lk1.lookup_code forms_opt_code, lk2.lookup_code ss_opt_code, lk1.meaning
3235: FROM fnd_lookup_values lk1, fnd_lookup_values lk2
3236: WHERE lk1.lookup_type = 'PA_OPTIONS'
3237: AND lk2.lookup_type = 'PA_OPTIONS_SS'
3238: AND lk1.meaning = lk2.meaning
3239: ;