APPS.PA_UTILS3 dependencies on PA_PROJECT_TYPES_ALL

Line 507: l_project_type_class_code pa_project_types_all.project_type_class_code%TYPE;

503: (p_project_id IN pa_projects_all.project_id%TYPE,
504: x_asset_addition_flag OUT NOCOPY ap_invoice_distributions_all.assets_addition_flag%TYPE)
505: IS
506:
507: l_project_type_class_code pa_project_types_all.project_type_class_code%TYPE;
508:
509: BEGIN
510:
511: /* For Given Project Id, Get the Project_Type_Class_Code depending on the Project_Type */

Line 514: FROM pa_project_types_all ptype,

510:
511: /* For Given Project Id, Get the Project_Type_Class_Code depending on the Project_Type */
512: SELECT ptype.project_type_class_code
513: INTO l_project_type_class_code
514: FROM pa_project_types_all ptype,
515: pa_projects_all proj
516: WHERE ptype.project_type = proj.project_type
517: AND NVL(ptype.org_id, -99) = NVL(proj.org_id, -99)
518: AND proj.project_id = p_project_id;

Line 558: FROM pa_project_types_all ptype,

554: /* For Given Project Id, Get the Project_Type_Class_Code depending on the Project_Type */
555:
556: SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
557: INTO l_project_type
558: FROM pa_project_types_all ptype,
559: pa_projects_all proj
560: WHERE proj.project_type = ptype.project_type
561: /* AND NVL(ptype.org_id, -99) = NVL(proj.org_id, -99) commented and removed nvl to make use of the index also in R12, org is populated --Bug 5912873*/
562: AND ptype.org_id = proj.org_id