APPS.PA_FP_GEN_FCST_AMT_PUB dependencies on PA_FP_MERGED_CTRL_ITEMS

Line 685: FROM pa_fp_merged_ctrl_items pfmci

681:
682: SELECT pfmci.ci_id
683: BULK COLLECT
684: INTO l_ci_id_tbl
685: FROM pa_fp_merged_ctrl_items pfmci
686: WHERE pfmci.plan_version_id = P_FP_COLS_REC.X_BUDGET_VERSION_ID
687: AND NOT EXISTS ( SELECT 1 FROM pa_fp_merged_ctrl_items pfmci1
688: WHERE pfmci1.plan_version_id = P_FP_COLS_REC.X_GEN_SRC_PLAN_VERSION_ID
689: AND pfmci.ci_id = pfmci1.ci_id);

Line 687: AND NOT EXISTS ( SELECT 1 FROM pa_fp_merged_ctrl_items pfmci1

683: BULK COLLECT
684: INTO l_ci_id_tbl
685: FROM pa_fp_merged_ctrl_items pfmci
686: WHERE pfmci.plan_version_id = P_FP_COLS_REC.X_BUDGET_VERSION_ID
687: AND NOT EXISTS ( SELECT 1 FROM pa_fp_merged_ctrl_items pfmci1
688: WHERE pfmci1.plan_version_id = P_FP_COLS_REC.X_GEN_SRC_PLAN_VERSION_ID
689: AND pfmci.ci_id = pfmci1.ci_id);
690:
691: l_budget_version_id_tbl.extend;

Line 695: FROM pa_fp_merged_ctrl_items pfmci

691: l_budget_version_id_tbl.extend;
692: l_budget_version_id_tbl(1) := P_FP_COLS_REC.X_BUDGET_VERSION_ID;
693:
694: DELETE
695: FROM pa_fp_merged_ctrl_items pfmci
696: WHERE pfmci.plan_version_id = P_FP_COLS_REC.X_BUDGET_VERSION_ID
697: AND NOT EXISTS ( SELECT 1 FROM pa_fp_merged_ctrl_items pfmci1
698: WHERE pfmci1.plan_version_id = P_FP_COLS_REC.X_GEN_SRC_PLAN_VERSION_ID
699: AND pfmci.ci_id = pfmci1.ci_id);

Line 697: AND NOT EXISTS ( SELECT 1 FROM pa_fp_merged_ctrl_items pfmci1

693:
694: DELETE
695: FROM pa_fp_merged_ctrl_items pfmci
696: WHERE pfmci.plan_version_id = P_FP_COLS_REC.X_BUDGET_VERSION_ID
697: AND NOT EXISTS ( SELECT 1 FROM pa_fp_merged_ctrl_items pfmci1
698: WHERE pfmci1.plan_version_id = P_FP_COLS_REC.X_GEN_SRC_PLAN_VERSION_ID
699: AND pfmci.ci_id = pfmci1.ci_id);
700:
701: