APPS.PA_UTILS2 dependencies on PA_PROJECT_TYPES_ALL

Line 4866: FROM pa_project_types_all pt

4862: SELECT DECODE(pt.burden_amt_display_method, 'D', 'D'
4863: , DECODE(pt.BURDEN_SUM_DEST_PROJECT_ID, NULL
4864: , DECODE(pt.BURDEN_SUM_DEST_TASK_ID, NULL, 'S', 'D'), 'D'))
4865: INTO x_burden_method
4866: FROM pa_project_types_all pt
4867: ,pa_projects_all p
4868: WHERE p.project_id = P_Project_Id
4869: AND p.project_type = pt.project_type
4870: AND pt.org_id = p.org_id

Line 4926: FROM pa_project_types_all pt

4922: Begin
4923: --Dbms_Output.Put_Line('select');
4924: SELECT pt.burden_amt_display_method
4925: INTO x_burden_method
4926: FROM pa_project_types_all pt
4927: ,pa_projects_all p
4928: WHERE p.project_id = P_Project_Id
4929: AND p.project_type = pt.project_type
4930: -- begin bug 5614790

Line 4958: RETURN pa_project_types_all.CAPITAL_COST_TYPE_CODE%TYPE

4954:
4955: /* E.N. Bug4746949 */
4956:
4957: Function get_capital_cost_type_code( p_project_id IN pa_projects_all.project_id%TYPE)
4958: RETURN pa_project_types_all.CAPITAL_COST_TYPE_CODE%TYPE
4959: Is
4960: l_Found BOOLEAN := FALSE;
4961: x_capital_cost_type VARCHAR2(1);
4962: Begin

Line 4990: FROM pa_project_types_all pt

4986: Begin
4987: --Dbms_Output.Put_Line('select');
4988: SELECT pt.capital_cost_type_code
4989: INTO x_capital_cost_type
4990: FROM pa_project_types_all pt
4991: ,pa_projects_all p
4992: WHERE p.project_id = P_Project_Id
4993: AND p.project_type = pt.project_type
4994: -- begin bug 5614790