APPS.PA_FP_CI_INCLUDE_PKG SQL Statements

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

Line: 117

            SELECT bv.project_id
            INTO l_source_project_id
            FROM pa_control_items bv
            WHERE
            bv.ci_id = l_s_fp_ci_id;

Line: 222

                    SELECT bv.project_id
                    INTO l_source_project_id
                    FROM pa_control_items bv
                    WHERE
                    bv.ci_id = l_s_fp_ci_id;

Line: 369

      SELECT  a.*
        FROM  pa_ci_impacts a
       WHERE  a.ci_id = p_source_ci_id
         AND  a.impact_type_code IN ('FINPLAN_COST','FINPLAN_REVENUE','FINPLAN')
         AND (a.impact_type_code = 'FINPLAN' OR
                EXISTS (SELECT 1
                          FROM pa_control_items targetCi,
                               pa_ci_impact_type_usage targetUsage
                         WHERE targetCi.ci_id = p_target_ci_id
                           AND targetCi.ci_type_id = targetUsage.ci_type_id
                           AND targetUsage.impact_type_code = a.impact_type_code));

Line: 385

      SELECT ci_impact_id, description, implementation_comment,
             implementation_date, implemented_by, record_version_number,
             impacted_task_id
      FROM   pa_ci_impacts
      WHERE  ci_id = p_target_ci_id
      AND    impact_type_code = l_impact_type_code;

Line: 444

        select 'Y'
        into   l_appr_bdgt_pt_exists
        from   dual
        where  exists
               (select 1 from pa_proj_fp_options
                where  project_id = p_project_id
                and    approved_cost_plan_type_flag = 'Y'
                and    approved_rev_plan_type_flag = 'Y'
                and    fin_plan_option_level_code = 'PLAN_TYPE'
                and    fin_plan_preference_code = 'COST_AND_REV_SAME');

Line: 461

    SELECT count(*)
    INTO   l_allowed_impacts_count
    FROM   pa_control_items pci,
           pa_ci_impact_type_usage pcit
    WHERE  pci.ci_type_id = pcit.ci_type_id
    AND    pci.ci_id = p_target_ci_id
    AND    impact_type_code IN ('FINPLAN_COST','FINPLAN_REVENUE');

Line: 497

           pa_ci_impacts_pkg.insert_row(
                         l_rowid,
                         l_new_ci_impact_id,
                         p_target_ci_id,
                         rec.impact_type_code,
                         'CI_IMPACT_PENDING',
                         rec.description,
                         NULL,
                         NULL,
                         NULL,
                         rec.impacted_task_id,
                         sysdate,
                         fnd_global.user_id,
                         Sysdate,
                         fnd_global.user_id,
                         fnd_global.login_id
                        );

Line: 518

           pa_ci_impacts_pkg.update_row(
                         l_ci_impact_id,
                         p_target_ci_id,
                         l_impact_type_code,
                         NULL,
                         l_temp2,
                         l_implementation_date,
                         l_implemented_by,
                         l_comment,
                         Nvl(l_task_id, rec.impacted_task_id),
                         sysdate,
                         fnd_global.user_id,
                         fnd_global.login_id,
                         l_record_ver_number
                        );