APPS.PA_UTILS2 dependencies on PA_PROJECTS_ALL

Line 489: FROM pa_projects_all

485: -- This section of IF is executed if project id is
486: -- passed to the function
487: SELECT org_id
488: INTO l_org_id
489: FROM pa_projects_all
490: WHERE project_id = p_project_id ;
491:
492: G_PREV_ORG_ID2 := l_org_id;
493:

Line 504: FROM pa_projects_all p,

500: -- passed without a project id.
501:
502: SELECT p.org_id
503: INTO l_org_id
504: FROM pa_projects_all p,
505: pa_tasks t
506: WHERE p.project_id = t.project_id
507: AND t.task_id = p_task_id ;
508:

Line 4867: ,pa_projects_all p

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
4871: AND pt.burden_cost_flag = 'Y';

Line 4927: ,pa_projects_all p

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
4931: -- AND NVL(pt.org_id,-99) = nvl(p.org_id,-99)

Line 4957: Function get_capital_cost_type_code( p_project_id IN pa_projects_all.project_id%TYPE)

4953: End Proj_Type_Burden_Disp_Method;
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);

Line 4991: ,pa_projects_all p

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
4995: -- AND NVL(pt.org_id,-99) = nvl(p.org_id,-99)