DBA Data[Home] [Help]

APPS.PA_FP_UPGRADE_PKG dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 4402: and NVL(pa_project_structure_utils.check_struc_ver_published(bv.project_id,bv.project_structure_version_id),'N') = 'N'

4398: and nvl(c_fin_plan_type_id,fp.fin_plan_type_id) = fp.fin_plan_type_id
4399: and nvl(fp.FIN_PLAN_TYPE_CODE,'x') <> 'ORG_FORECAST'
4400: and bv.budget_status_code = 'W'
4401: and bv.ci_id = ci.ci_id(+)
4402: and NVL(pa_project_structure_utils.check_struc_ver_published(bv.project_id,bv.project_structure_version_id),'N') = 'N'
4403: and NOT EXISTS (SELECT 1 FROM pa_fp_upgrade_audit aud
4404: WHERE aud.project_id = op.project_id
4405: AND aud.proj_fp_options_id_rup = op.PROJ_FP_OPTIONS_ID
4406: AND aud.upgraded_flag = 'Y')