APPS.PA_FP_GEN_AMT_WRP_PKG SQL Statements

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

Line: 121

    l_sel_clause   := ' SELECT  distinct pj.project_id, opt.fin_plan_type_id,'
                    ||' opt.FIN_PLAN_PREFERENCE_CODE,pt.PLAN_CLASS_CODE'
                    ||',pj.name'||
       -- gboomina added for AAI Requirement 8318932 - start
       -- select ETC source code, Time Phase and Copy ETC from Plan flag
       -- to validate the target financial plan if Copy ETC from plan flag
       -- is selected
                ' ,opt.GEN_COST_ETC_SRC_CODE, opt.COST_TIME_PHASED_CODE, ' ||  --Bug 9322311
                'opt.COPY_ETC_FROM_PLAN_FLAG';

Line: 185

    SELECT  min(pj.segment1)
    INTO    l_from_proj_no
    FROM    pa_projects pj /* Bug 5657334 */
    WHERE   NVL(PA_PROJECT_STUS_UTILS.Is_Project_Status_Closed(pj.project_status_code),'N') <> 'Y';

Line: 201

    SELECT  max(pj.segment1)
    INTO l_to_proj_no
    FROM pa_projects pj /* Bug 5657334 */
    WHERE NVL(PA_PROJECT_STUS_UTILS.Is_Project_Status_Closed(pj.project_status_code),'N') <> 'Y';

Line: 332

           SELECT name INTO l_plan_type_name FROM pa_fin_plan_types_tl
           WHERE
           fin_plan_type_id = l_plan_type_id AND
           language = USERENV('LANG');

Line: 373

    l_element_type_tab.delete;

Line: 654

                    SELECT count(*) INTO l_fin_plan_count
                    FROM   pa_tasks
                    WHERE  project_id = l_proj_id
                    AND    gen_etc_source_code = lc_FinancialPlan
                    AND    rownum < 2;

Line: 664

                    SELECT count(*) INTO l_workplan_count
                    FROM   pa_tasks
                    WHERE  project_id = l_proj_id
                    AND    gen_etc_source_code = lc_WorkplanResources
                    AND    rownum < 2;

Line: 683

                            select project_structure_version_id into l_etc_wp_struct_ver_id
                            from pa_budget_versions
                            where budget_version_id = l_etc_wp_fin_ver_id;

Line: 743

                          wp_fin_plan_ver_id to update back to pa_proj_fp_options*/

                END IF; -- l_workplan_src_dtls_flag

Line: 751

                		SELECT fin_plan_preference_code
								    INTO   l_fp_preference_code
								    FROM   pa_proj_fp_options
								    WHERE  project_id = l_proj_id
								    AND    fin_plan_type_id = l_fp_cols_rec.X_GEN_SRC_PLAN_TYPE_ID
								    AND    fin_plan_option_level_code =
								           PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;

Line: 864

                    SELECT version_name INTO l_etc_fp_ver_name
                    FROM pa_budget_versions
                    WHERE budget_version_id = l_etc_fp_ver_id;

Line: 923

        /*update the etc source version id back to pa_proj_fp_options*/
        IF l_element_type_tab(i) = 'COST' THEN
            UPDATE PA_PROJ_FP_OPTIONS
            SET GEN_SRC_COST_PLAN_TYPE_ID = l_etc_fp_type_id,
                GEN_SRC_COST_PLAN_VERSION_ID = l_etc_fp_ver_id,
                GEN_SRC_COST_WP_VERSION_ID = l_etc_wp_fin_ver_id
            WHERE fin_plan_version_id = lx_budget_version_id;

Line: 931

            UPDATE PA_PROJ_FP_OPTIONS
            SET GEN_SRC_REV_PLAN_TYPE_ID = l_etc_fp_type_id,
                GEN_SRC_REV_PLAN_VERSION_ID = l_etc_fp_ver_id,
                GEN_SRC_REV_WP_VERSION_ID = l_etc_wp_fin_ver_id
            WHERE fin_plan_version_id = lx_budget_version_id;

Line: 937

            UPDATE PA_PROJ_FP_OPTIONS
            SET GEN_SRC_ALL_PLAN_TYPE_ID = l_etc_fp_type_id,
                GEN_SRC_ALL_PLAN_VERSION_ID = l_etc_fp_ver_id,
                GEN_SRC_ALL_WP_VERSION_ID = l_etc_wp_fin_ver_id
            WHERE fin_plan_version_id = lx_budget_version_id;

Line: 948

    UPDATE  PA_BUDGET_VERSIONS
    SET     ACTUAL_AMTS_THRU_PERIOD = l_act_thru_period
    WHERE   BUDGET_VERSION_ID       = lx_budget_version_id;