APPS.PA_AP_INTEGRATION dependencies on PA_PROJECT_TYPES_ALL

Line 526: l_project_type_class_code pa_project_types_all.project_type_class_code%TYPE;

522: (p_project_id IN pa_projects_all.project_id%TYPE,
523: x_asset_addition_flag OUT NOCOPY ap_invoice_distributions_all.assets_addition_flag%TYPE)
524: IS
525:
526: l_project_type_class_code pa_project_types_all.project_type_class_code%TYPE;
527:
528: BEGIN
529:
530: /* For Given Project Id, Get the Project_Type_Class_Code depending on the Project_Type */

Line 533: FROM pa_project_types_all ptype,

529:
530: /* For Given Project Id, Get the Project_Type_Class_Code depending on the Project_Type */
531: SELECT ptype.project_type_class_code
532: INTO l_project_type_class_code
533: FROM pa_project_types_all ptype,
534: pa_projects_all proj
535: WHERE ptype.project_type = proj.project_type
536: --R12 AND NVL(ptype.org_id, -99) = NVL(proj.org_id, -99)
537: AND ptype.org_id = proj.org_id

Line 578: FROM pa_project_types_all ptype,

574: /* For Given Project Id, Get the Project_Type_Class_Code depending on the Project_Type */
575:
576: SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
577: INTO l_project_type
578: FROM pa_project_types_all ptype,
579: pa_projects_all proj
580: WHERE proj.project_type = ptype.project_type
581: -- R12 AND NVL(ptype.org_id, -99) = NVL(proj.org_id, -99)
582: AND ptype.org_id = proj.org_id