APPS.PA_AP_INTEGRATION dependencies on PA_PROJECT_TYPES_ALL

Line 462: l_project_type_class_code pa_project_types_all.project_type_class_code%TYPE;

458: (p_project_id IN pa_projects_all.project_id%TYPE,
459: x_asset_addition_flag OUT NOCOPY ap_invoice_distributions_all.assets_addition_flag%TYPE)
460: IS
461:
462: l_project_type_class_code pa_project_types_all.project_type_class_code%TYPE;
463:
464: BEGIN
465:
466: /* For Given Project Id, Get the Project_Type_Class_Code depending on the Project_Type */

Line 469: FROM pa_project_types_all ptype,

465:
466: /* For Given Project Id, Get the Project_Type_Class_Code depending on the Project_Type */
467: SELECT ptype.project_type_class_code
468: INTO l_project_type_class_code
469: FROM pa_project_types_all ptype,
470: pa_projects_all proj
471: WHERE ptype.project_type = proj.project_type
472: --R12 AND NVL(ptype.org_id, -99) = NVL(proj.org_id, -99)
473: AND ptype.org_id = proj.org_id

Line 514: FROM pa_project_types_all ptype,

510: /* For Given Project Id, Get the Project_Type_Class_Code depending on the Project_Type */
511:
512: SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
513: INTO l_project_type
514: FROM pa_project_types_all ptype,
515: pa_projects_all proj
516: WHERE proj.project_type = ptype.project_type
517: -- R12 AND NVL(ptype.org_id, -99) = NVL(proj.org_id, -99)
518: AND ptype.org_id = proj.org_id