DBA Data[Home] [Help]

APPS.PA_COST dependencies on PA_PROJECT_TYPES_ALL

Line 540: l_burden_cost_flag pa_project_types_all.burden_cost_flag%TYPE;

536: x_msg_data OUT NOCOPY VARCHAR2
537: )
538: IS
539:
540: l_burden_cost_flag pa_project_types_all.burden_cost_flag%TYPE;
541: l_burden_amt_disp_method pa_project_types_all.burden_amt_display_method%TYPE;
542: l_x_burden_sch_fixed_date DATE;
543: l_x_burden_sch_revision_id NUMBER;
544: l_burden_sch_revision_id NUMBER;

Line 541: l_burden_amt_disp_method pa_project_types_all.burden_amt_display_method%TYPE;

537: )
538: IS
539:
540: l_burden_cost_flag pa_project_types_all.burden_cost_flag%TYPE;
541: l_burden_amt_disp_method pa_project_types_all.burden_amt_display_method%TYPE;
542: l_x_burden_sch_fixed_date DATE;
543: l_x_burden_sch_revision_id NUMBER;
544: l_burden_sch_revision_id NUMBER;
545: l_cost_base VARCHAR2(30);

Line 612: FROM pa_project_types_all typ, pa_projects_all proj

608: ------------------------------------------------------
609: -- Bug 7423839 removed refernce to project type
610: SELECT burden_cost_flag
611: INTO l_burden_cost_flag
612: FROM pa_project_types_all typ, pa_projects_all proj
613: WHERE proj.project_id = p_project_id
614: AND proj.project_type = typ.project_type
615: AND proj.org_id = typ.org_id; -- bug 5365286
616: /* Commented for Bug 7423839

Line 619: FROM pa_project_types_all typ, pa_projects_all proj

615: AND proj.org_id = typ.org_id; -- bug 5365286
616: /* Commented for Bug 7423839
617: SELECT burden_cost_flag
618: INTO l_burden_cost_flag
619: FROM pa_project_types_all typ, pa_projects_all proj
620: WHERE typ.project_type = P_project_type
621: AND proj.project_type = typ.project_type
622: AND proj.project_id = p_project_id
623: AND proj.org_id = typ.org_id; -- bug 5365286