DBA Data[Home] [Help]

APPS.PA_FP_GEN_PUB dependencies on PA_FP_MERGED_CTRL_ITEMS

Line 550: FROM pa_fp_merged_ctrl_items merge

546: AND (pfc.REV_PARTIALLY_IMPL_FLAG='Y'
547: OR (pfc.ci_version_type='ALL' AND
548: decode(p_fp_cols_rec.x_version_type,'ALL',2,1) >
549: (SELECT COUNT(*)
550: FROM pa_fp_merged_ctrl_items merge
551: WHERE merge.ci_plan_version_id = pfc.ci_version_id
552: AND merge.plan_version_id = p_fp_cols_rec.x_budget_version_id))
553: OR (pfc.ci_version_type <> 'ALL' AND
554: NOT EXISTS (SELECT 'X'

Line 555: FROM pa_fp_merged_ctrl_items merge

551: WHERE merge.ci_plan_version_id = pfc.ci_version_id
552: AND merge.plan_version_id = p_fp_cols_rec.x_budget_version_id))
553: OR (pfc.ci_version_type <> 'ALL' AND
554: NOT EXISTS (SELECT 'X'
555: FROM pa_fp_merged_ctrl_items merge
556: WHERE merge.ci_plan_version_id = pfc.ci_version_id
557: AND merge.plan_version_id = p_fp_cols_rec.x_budget_version_id
558: AND merge.version_type = pfc.ci_version_type)))
559: AND pfc.project_system_status_code = pal.lookup_code