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 828: FROM pa_lookups

824: DECLARE
825: CURSOR cur_copy_overrides
826: IS
827: SELECT lookup_code, meaning
828: FROM pa_lookups
829: WHERE lookup_type = 'OVERRIDE FIELD'
830: AND lookup_code = 'SEGMENT1'
831: UNION
832: SELECT lookup_code, meaning

Line 833: FROM pa_lookups

829: WHERE lookup_type = 'OVERRIDE FIELD'
830: AND lookup_code = 'SEGMENT1'
831: UNION
832: SELECT lookup_code, meaning
833: FROM pa_lookups
834: WHERE lookup_type = 'OVERRIDE FIELD'
835: AND lookup_code = 'NAME'
836: ORDER BY 1 DESC;
837:

Line 1805: , pa_lookups lps

1801:
1802: select meaning
1803: into l_project_type_class_code
1804: from pa_project_types pt
1805: , pa_lookups lps
1806: where pt.project_type = p_project_type
1807: and lps.lookup_type(+) = 'PROJECT TYPE CLASS'
1808: and lps.lookup_code(+) = pt.project_type_class_code;
1809:

Line 2744: pa_lookups pl

2740:
2741: SELECT 'X'
2742: INTO l_dummy_char
2743: FROM pa_valid_categories_v pvc ,
2744: pa_lookups pl
2745: WHERE pvc.object_type = 'PA_PROJECTS'
2746: AND pvc.object_type_id = l_project_type_id
2747: AND 'CLASSIFICATION' = pl.lookup_code
2748: AND pl.lookup_type = 'OVERRIDE FIELD'

Line 3040: pa_lookups pl

3036:
3037: SELECT 'X'
3038: INTO l_dummy_char
3039: FROM pa_valid_categories_v pvc ,
3040: pa_lookups pl
3041: WHERE pvc.object_type = 'PA_PROJECTS'
3042: AND pvc.object_type_id = l_project_type_id
3043: AND 'CLASSIFICATION' = pl.lookup_code
3044: AND pl.lookup_type = 'OVERRIDE FIELD'