APPS.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on PA_LOOKUPS

Line 534: from pa_project_types pt ,pa_lookups lps

530: if x_err_stage = 'PA_INVALID_PT_CLASS_ORG' then
531:
532: select meaning
533: into t_project_type_class_code
534: from pa_project_types pt ,pa_lookups lps
535: where pt.project_type = p_project_type
536: and lps.lookup_type(+) = 'PROJECT TYPE CLASS'
537: and lps.lookup_code(+) = pt.project_type_class_code;
538:

Line 823: FROM pa_lookups

819: DECLARE
820: CURSOR cur_copy_overrides
821: IS
822: SELECT lookup_code, meaning
823: FROM pa_lookups
824: WHERE lookup_type = 'OVERRIDE FIELD'
825: AND lookup_code = 'SEGMENT1'
826: UNION
827: SELECT lookup_code, meaning

Line 828: FROM pa_lookups

824: WHERE lookup_type = 'OVERRIDE FIELD'
825: AND lookup_code = 'SEGMENT1'
826: UNION
827: SELECT lookup_code, meaning
828: FROM pa_lookups
829: WHERE lookup_type = 'OVERRIDE FIELD'
830: AND lookup_code = 'NAME'
831: ORDER BY 1 DESC;
832:

Line 1800: , pa_lookups lps

1796:
1797: select meaning
1798: into l_project_type_class_code
1799: from pa_project_types pt
1800: , pa_lookups lps
1801: where pt.project_type = p_project_type
1802: and lps.lookup_type(+) = 'PROJECT TYPE CLASS'
1803: and lps.lookup_code(+) = pt.project_type_class_code;
1804:

Line 2739: pa_lookups pl

2735:
2736: SELECT 'X'
2737: INTO l_dummy_char
2738: FROM pa_valid_categories_v pvc ,
2739: pa_lookups pl
2740: WHERE pvc.object_type = 'PA_PROJECTS'
2741: AND pvc.object_type_id = l_project_type_id
2742: AND 'CLASSIFICATION' = pl.lookup_code
2743: AND pl.lookup_type = 'OVERRIDE FIELD'

Line 3035: pa_lookups pl

3031:
3032: SELECT 'X'
3033: INTO l_dummy_char
3034: FROM pa_valid_categories_v pvc ,
3035: pa_lookups pl
3036: WHERE pvc.object_type = 'PA_PROJECTS'
3037: AND pvc.object_type_id = l_project_type_id
3038: AND 'CLASSIFICATION' = pl.lookup_code
3039: AND pl.lookup_type = 'OVERRIDE FIELD'