DBA Data[Home] [Help]

APPS.PA_COST dependencies on PA_PROJECT_TYPES_ALL

Line 515: l_burden_cost_flag pa_project_types_all.burden_cost_flag%TYPE;

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;

Line 516: l_burden_amt_disp_method pa_project_types_all.burden_amt_display_method%TYPE;

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);

Line 586: FROM pa_project_types_all typ, pa_projects_all proj

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