DBA Data[Home] [Help]

APPS.PA_FP_GEN_AMT_WRP_PKG SQL Statements

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

Line: 108

    l_sel_clause   := ' SELECT  distinct pj.project_id, opt.fin_plan_type_id,'
                    ||' opt.FIN_PLAN_PREFERENCE_CODE,pt.PLAN_CLASS_CODE'
                    ||',pj.name';
Line: 165

    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: 181

    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: 293

    l_element_type_tab.delete;
Line: 371

                 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: 581

                    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: 591

                    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: 610

                            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: 670

                          wp_fin_plan_ver_id to update back to pa_proj_fp_options*/

                END IF; -- l_workplan_src_dtls_flag
Line: 774

                    SELECT version_name INTO l_etc_fp_ver_name
                    FROM pa_budget_versions
                    WHERE budget_version_id = l_etc_fp_ver_id;
Line: 784

        /*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: 792

            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: 798

            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;