APPS.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on FND_LOOKUP_VALUES

Line 2428: FROM fnd_lookup_values

2424:
2425: CURSOR cur_option_name
2426: IS
2427: SELECT meaning
2428: FROM fnd_lookup_values
2429: WHERE lookup_type = 'PA_OPTIONS_SS'
2430: AND lookup_code = p_option_code
2431: AND language = userenv('LANG'); -- Bug 5643345: Added the environment language condition.
2432: -- anlee

Line 2671: FROM fnd_lookup_values

2667: THEN
2668: BEGIN
2669: SELECT meaning
2670: INTO l_field_name_meaning
2671: FROM fnd_lookup_values
2672: WHERE lookup_type = 'OVERRIDE FIELD'
2673: AND lookup_code = p_field_name;
2674: EXCEPTION
2675: WHEN NO_DATA_FOUND THEN

Line 2967: FROM fnd_lookup_values

2963: THEN
2964: BEGIN
2965: SELECT meaning
2966: INTO l_field_name_meaning
2967: FROM fnd_lookup_values
2968: WHERE lookup_type = 'OVERRIDE FIELD'
2969: AND lookup_code = p_field_name;
2970: EXCEPTION
2971: WHEN NO_DATA_FOUND THEN

Line 3240: FROM fnd_lookup_values lk1, fnd_lookup_values lk2

3236:
3237: CURSOR cur_pa_lkups
3238: IS
3239: SELECT lk1.lookup_code forms_opt_code, lk2.lookup_code ss_opt_code, lk1.meaning
3240: FROM fnd_lookup_values lk1, fnd_lookup_values lk2
3241: WHERE lk1.lookup_type = 'PA_OPTIONS'
3242: AND lk2.lookup_type = 'PA_OPTIONS_SS'
3243: AND lk1.meaning = lk2.meaning
3244: ;