APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on FF_FORMULAS_F

Line 5821: -- START OF FF_FORMULAS_F ----------------------

5817: -- and cpe.table_route_id = trt.table_route_id
5818: and cpe.table_alias = c_parent_table_alias ;
5819: ---
5820: ---------------------------------------------------------------
5821: -- START OF FF_FORMULAS_F ----------------------
5822: ---------------------------------------------------------------
5823: -- We get the only the formula
5824: cursor c_fff(c_formula_id number,c_mirror_src_entity_result_id number ,
5825: c_table_alias varchar2) is

Line 5827: from FF_FORMULAS_F fff,FF_FORMULA_TYPES ft

5823: -- We get the only the formula
5824: cursor c_fff(c_formula_id number,c_mirror_src_entity_result_id number ,
5825: c_table_alias varchar2) is
5826: select fff.*,fff.formula_text ff_text,ft.formula_type_name formula_type_name
5827: from FF_FORMULAS_F fff,FF_FORMULA_TYPES ft
5828: where fff.formula_id = c_formula_id
5829: and fff.formula_type_id = ft.formula_type_id
5830: and ( fff.business_group_id = p_business_group_id or fff.business_group_id is null )
5831: and not exists (

Line 5846: -- END OF FF_FORMULAS_F ----------------------

5842: );
5843: l_FORMULA_ID number(15);
5844: l_out_fff_result_id number(15);
5845: ---------------------------------------------------------------
5846: -- END OF FF_FORMULAS_F ----------------------
5847: ---------------------------------------------------------------
5848:
5849: cursor c_object_exists(c_pk_id number,
5850: c_table_alias varchar2) is

Line 5899: -- START OF FF_FORMULAS_F ----------------------

5895: end if;
5896: --End Bug 4945193
5897:
5898: ---------------------------------------------------------------
5899: -- START OF FF_FORMULAS_F ----------------------
5900: ---------------------------------------------------------------
5901: --
5902: l_mirror_src_entity_result_id := p_copy_entity_result_id ;
5903: --

Line 5968: ff_formulas_f fff

5964: -- RKG Placeholder for copying formula text to clob column
5965:
5966:
5967: select fff.formula_text into l_ff_formula_text_long from
5968: ff_formulas_f fff
5969: where fff.formula_id = l_fff_rec.FORMULA_ID
5970: and fff.effective_start_Date = l_fff_rec.EFFECTIVE_START_DATE
5971: and fff.effective_end_date = l_fff_rec.EFFECTIVE_END_DATE
5972: --and fff.business_Group_id = l_fff_rec.business_group_id;

Line 5998: -- END OF FF_FORMULAS_F ----------------------

5994: --
5995: end loop;
5996: --
5997: ---------------------------------------------------------------
5998: -- END OF FF_FORMULAS_F ----------------------
5999: ---------------------------------------------------------------
6000: end create_formula_result;
6001: --
6002: procedure create_actn_typ_result

Line 6440: l_formula_name ff_formulas_f.formula_name%type := null;

6436: p_formula_id in number
6437: ,p_effective_date in date
6438: ) return varchar2 is
6439:
6440: l_formula_name ff_formulas_f.formula_name%type := null;
6441:
6442: cursor c_formula_name is
6443: select ff.formula_name
6444: from ff_formulas_f ff

Line 6444: from ff_formulas_f ff

6440: l_formula_name ff_formulas_f.formula_name%type := null;
6441:
6442: cursor c_formula_name is
6443: select ff.formula_name
6444: from ff_formulas_f ff
6445: where ff.formula_id = p_formula_id
6446: and p_effective_date between ff.effective_start_date
6447: and ff.effective_end_date;
6448: begin