APPS.PA_FP_GEN_FCST_AMT_PUB1 dependencies on PA_PROJ_FP_OPTIONS

Line 3924: l_etc_wp_ver_code PA_PROJ_FP_OPTIONS.GEN_SRC_COST_WP_VER_CODE%type;

3920: IS
3921: l_project_id number;
3922: l_etc_wp_bdgt_ver_id number;
3923: l_versioning_enabled varchar2(30);
3924: l_etc_wp_ver_code PA_PROJ_FP_OPTIONS.GEN_SRC_COST_WP_VER_CODE%type;
3925: l_etc_wp_ver_id VARCHAR2(100);
3926: l_etc_wp_ver_name PA_PROJ_ELEM_VER_STRUCTURE.name%type;
3927: l_dummy VARCHAR2(100):=null;
3928: BEGIN

Line 3941: FROM PA_PROJ_FP_OPTIONS OPT,PA_PROJ_FP_OPTIONS OPT1,

3937: BV.PROJECT_ID
3938: INTO l_etc_wp_bdgt_ver_id,
3939: l_etc_wp_ver_code,
3940: l_project_id
3941: FROM PA_PROJ_FP_OPTIONS OPT,PA_PROJ_FP_OPTIONS OPT1,
3942: PA_BUDGET_VERSIONS BV
3943: WHERE OPT.FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID
3944: AND OPT.FIN_PLAN_VERSION_ID = BV.BUDGET_VERSION_ID
3945: --AND OPT.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_VERSION'

Line 4030: FROM PA_PROJ_FP_OPTIONS OPT,

4026: 'ALL',OPT.GEN_SRC_ALL_PLAN_TYPE_ID),
4027: PT.NAME
4028: INTO l_src_plan_type_id,
4029: l_src_plan_type_name
4030: FROM PA_PROJ_FP_OPTIONS OPT,
4031: PA_BUDGET_VERSIONS BV,
4032: pa_fin_plan_types_vl PT
4033: WHERE
4034: OPT.FIN_PLAN_VERSION_ID = P_BUDGET_VERSION_ID

Line 4092: FROM PA_PROJ_FP_OPTIONS OPT, PA_PROJ_FP_OPTIONS OPT1,

4088: INTO l_etc_fp_ver_id,
4089: l_etc_fp_ver_code,
4090: l_src_plan_type_id,
4091: l_project_id
4092: FROM PA_PROJ_FP_OPTIONS OPT, PA_PROJ_FP_OPTIONS OPT1,
4093: PA_BUDGET_VERSIONS BV
4094: WHERE BV.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
4095: AND OPT.FIN_PLAN_VERSION_ID = BV.BUDGET_VERSION_ID
4096: AND OPT1.PROJECT_ID = BV.PROJECT_ID