APPS.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on PA_PROJECT_TYPES

Line 177: from pa_project_types

173:
174: Cursor Get_def_Res_List is
175: Select Default_Resource_List_Id,
176: pa_resource_list_assignments_s.nextval
177: from pa_project_types
178: where project_type = p_project_type;
179:
180: x_def_res_list_id Number := 0;
181: x_def_use_Code Varchar2(30) := 'ACTUALS_ACCUM';

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 1308: FROM pa_project_types_all

1304:
1305: CURSOR cur_project_type_class
1306: IS
1307: SELECT project_type_class_code
1308: FROM pa_project_types_all
1309: WHERE project_type = p_project_type;
1310:
1311: CURSOR cur_bill_flag( c_work_type_id NUMBER )
1312: IS

Line 1804: from pa_project_types pt

1800: if l_err_stage = 'PA_INVALID_PT_CLASS_ORG' then
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;

Line 2718: FROM pa_project_types ppt, pa_projects pp

2714: DECLARE
2715: CURSOR cur_pa_proj_type
2716: IS
2717: SELECT project_type_id
2718: FROM pa_project_types ppt, pa_projects pp
2719: WHERE project_id = p_project_id
2720: AND pp.project_type = ppt.project_type;
2721: l_project_type_id NUMBER;
2722: BEGIN

Line 3014: FROM pa_project_types ppt, pa_projects pp

3010: DECLARE
3011: CURSOR cur_pa_proj_type
3012: IS
3013: SELECT project_type_id
3014: FROM pa_project_types ppt, pa_projects pp
3015: WHERE project_id = p_project_id
3016: AND pp.project_type = ppt.project_type;
3017: l_project_type_id NUMBER;
3018: BEGIN