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 4829: ,pa_projects_all p

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

Line 4889: ,pa_projects_all p

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

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

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

Line 4953: ,pa_projects_all p

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