APPS.PA_UTILS2 dependencies on PA_PROJECT_TYPES_ALL

Line 4828: FROM pa_project_types_all pt

4824: SELECT DECODE(pt.burden_amt_display_method, 'D', 'D'
4825: , DECODE(pt.BURDEN_SUM_DEST_PROJECT_ID, NULL
4826: , DECODE(pt.BURDEN_SUM_DEST_TASK_ID, NULL, 'S', 'D'), 'D'))
4827: INTO x_burden_method
4828: FROM pa_project_types_all pt
4829: ,pa_projects_all p
4830: WHERE p.project_id = P_Project_Id
4831: AND p.project_type = pt.project_type
4832: AND pt.org_id = p.org_id

Line 4888: FROM pa_project_types_all pt

4884: Begin
4885: --Dbms_Output.Put_Line('select');
4886: SELECT pt.burden_amt_display_method
4887: INTO x_burden_method
4888: FROM pa_project_types_all pt
4889: ,pa_projects_all p
4890: WHERE p.project_id = P_Project_Id
4891: AND p.project_type = pt.project_type
4892: -- begin bug 5614790

Line 4920: RETURN pa_project_types_all.CAPITAL_COST_TYPE_CODE%TYPE

4916:
4917: /* E.N. Bug4746949 */
4918:
4919: Function get_capital_cost_type_code( p_project_id IN pa_projects_all.project_id%TYPE)
4920: RETURN pa_project_types_all.CAPITAL_COST_TYPE_CODE%TYPE
4921: Is
4922: l_Found BOOLEAN := FALSE;
4923: x_capital_cost_type VARCHAR2(1);
4924: Begin

Line 4952: FROM pa_project_types_all pt

4948: Begin
4949: --Dbms_Output.Put_Line('select');
4950: SELECT pt.capital_cost_type_code
4951: INTO x_capital_cost_type
4952: FROM pa_project_types_all pt
4953: ,pa_projects_all p
4954: WHERE p.project_id = P_Project_Id
4955: AND p.project_type = pt.project_type
4956: -- begin bug 5614790