APPS.PA_AP_INTEGRATION dependencies on PA_PROJECTS_ALL

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

454: ****************************************************************************/
455:
456:
457: PROCEDURE get_asset_addition_flag
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;

Line 470: pa_projects_all proj

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

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

501: Returns 'P' if the project is Capital otherwise 'U'
502: ****************************************************************************/
503:
504: FUNCTION Get_Project_Type
505: (p_project_id IN pa_projects_all.project_id%TYPE)RETURN VARCHAR2 IS
506: l_project_type VARCHAR2(1);
507:
508: BEGIN
509:

Line 515: pa_projects_all proj

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