APPS.PA_CI_SUPPLIER_UTILS dependencies on PA_PROJ_FP_OPTIONS

Line 1658: FROM pa_proj_fp_options pfo, pa_budget_versions pbv

1654:
1655: CURSOR cur(p_project_id number) is
1656: SELECT
1657: decode (NVL(all_resource_list_id,0),0,cost_resource_list_id , all_resource_list_id)
1658: FROM pa_proj_fp_options pfo, pa_budget_versions pbv
1659: WHERE pbv.project_id = p_project_id AND
1660: pbv.current_working_flag = 'Y' AND
1661: pbv.budget_status_code = 'W' AND
1662: Nvl(pbv.approved_cost_plan_type_flag,'N') = 'Y' AND

Line 1675: SELECT COUNT(*) INTO l_no_of_app_plan_types FROM Pa_Proj_Fp_Options

1671: BEGIN
1672: l_project_id := p_project_id;
1673:
1674: if l_project_id is not null then
1675: SELECT COUNT(*) INTO l_no_of_app_plan_types FROM Pa_Proj_Fp_Options
1676: WHERE
1677: Project_Id = l_project_id AND
1678: Fin_Plan_Option_Level_Code = 'PLAN_TYPE' AND
1679: ( NVL(Approved_Cost_Plan_Type_Flag ,'N') = 'Y' ) ;