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 5997: -- END OF FF_FORMULAS_F ----------------------

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

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

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

Line 6443: from ff_formulas_f ff

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