APPS.PA_FP_WP_GEN_AMT_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

       select opt.fin_plan_type_id  into l_pt_id
       from pa_proj_fp_options opt,
            pa_fin_plan_types_b pt
       where
       opt.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_TYPE' and
       opt.FIN_PLAN_TYPE_ID = pt.FIN_PLAN_TYPE_ID and
       nvl(pt.USE_FOR_WORKPLAN_FLAG,'N') = 'Y' and
       opt.project_id = p_project_id;

Line: 32

       select budget_version_id into l_ver_id
       from pa_budget_versions where
       project_id = p_project_id  and
	   project_structure_version_id = p_proj_str_ver_id and
           nvl(wp_version_flag,'N') = 'Y';

Line: 51

    SELECT NVL(TRACK_WORKPLAN_COSTS_FLAG,'N') INTO l_flag
    FROM pa_proj_fp_options opt, pa_fin_plan_types_b pt
    WHERE opt.project_id = P_PROJECT_ID
	  AND opt.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_TYPE'
	  AND pt.fin_plan_type_id = opt.fin_plan_type_id
  	  AND NVL(pt.USE_FOR_WORKPLAN_FLAG,'N') = 'Y';

Line: 68

    SELECT opt.cost_time_phased_code INTO l_time_phase_code
    FROM pa_proj_fp_options opt, pa_fin_plan_types_b pt
    WHERE opt.project_id = P_PROJECT_ID
          AND opt.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_TYPE'
          AND pt.fin_plan_type_id = opt.fin_plan_type_id
          AND NVL(pt.USE_FOR_WORKPLAN_FLAG,'N') = 'Y';