APPS.PA_AP_INTEGRATION dependencies on PA_PROJECTS_ALL

Line 522: (p_project_id IN pa_projects_all.project_id%TYPE,

518: ****************************************************************************/
519:
520:
521: PROCEDURE get_asset_addition_flag
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;

Line 534: pa_projects_all proj

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
538: AND proj.project_id = p_project_id;

Line 569: (p_project_id IN pa_projects_all.project_id%TYPE)RETURN VARCHAR2 IS

565: Returns 'P' if the project is Capital otherwise 'U'
566: ****************************************************************************/
567:
568: FUNCTION Get_Project_Type
569: (p_project_id IN pa_projects_all.project_id%TYPE)RETURN VARCHAR2 IS
570: l_project_type VARCHAR2(1);
571:
572: BEGIN
573:

Line 579: pa_projects_all proj

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
583: AND proj.project_id = p_project_id ;