511: x_msg_data OUT NOCOPY VARCHAR2
512: )
513: IS
514:
515: l_burden_cost_flag pa_project_types_all.burden_cost_flag%TYPE;
516: l_burden_amt_disp_method pa_project_types_all.burden_amt_display_method%TYPE;
517: l_x_burden_sch_fixed_date DATE;
518: l_x_burden_sch_revision_id NUMBER;
519: l_burden_sch_revision_id NUMBER;
512: )
513: IS
514:
515: l_burden_cost_flag pa_project_types_all.burden_cost_flag%TYPE;
516: l_burden_amt_disp_method pa_project_types_all.burden_amt_display_method%TYPE;
517: l_x_burden_sch_fixed_date DATE;
518: l_x_burden_sch_revision_id NUMBER;
519: l_burden_sch_revision_id NUMBER;
520: l_cost_base VARCHAR2(30);
582: -- Get the burden cost flag for the given project type.
583: ------------------------------------------------------
584: SELECT burden_cost_flag
585: INTO l_burden_cost_flag
586: FROM pa_project_types_all typ, pa_projects_all proj
587: WHERE typ.project_type = P_project_type
588: AND proj.project_type = typ.project_type
589: AND proj.project_id = p_project_id
590: AND proj.org_id = typ.org_id; -- bug 5365286