APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_OPT_F

Line 11580: -- START OF BEN_OPT_F ----------------------

11576: -- from pqh_table_route trt
11577: -- where trt.table_alias = c_parent_table_alias;
11578: --
11579: ---------------------------------------------------------------
11580: -- START OF BEN_OPT_F ----------------------
11581: ---------------------------------------------------------------
11582: cursor c_opt1(c_opt_id number,c_mirror_src_entity_result_id number,
11583: c_table_alias varchar2) is
11584: select opt.*

Line 11585: from BEN_OPT_F opt

11581: ---------------------------------------------------------------
11582: cursor c_opt1(c_opt_id number,c_mirror_src_entity_result_id number,
11583: c_table_alias varchar2) is
11584: select opt.*
11585: from BEN_OPT_F opt
11586: where opt.opt_id = c_opt_id
11587: -- and opt.business_group_id = p_business_group_id
11588: and not exists (
11589: select /*+ */ null

Line 11596: -- and trt.where_clause = 'BEN_OPT_F'

11592: where copy_entity_txn_id = p_copy_entity_txn_id
11593: -- and trt.table_route_id = cpe.table_route_id
11594: and ( -- c_mirror_src_entity_result_id is null or
11595: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
11596: -- and trt.where_clause = 'BEN_OPT_F'
11597: and cpe.table_alias = c_table_alias
11598: and information1 = c_opt_id
11599: -- and information4 = opt.business_group_id
11600: and information2 = opt.effective_start_date

Line 11609: from ben_opt_f

11605: --Mapping for CWB Group_pl_id
11606: --
11607: cursor c_grp_opt_name (p_group_opt_id in number) is
11608: select name group_opt_name
11609: from ben_opt_f
11610: where opt_id = p_group_opt_id
11611: and p_effective_date between effective_start_date and effective_end_date;
11612:
11613: l_mapping_id number;

Line 11623: -- END OF BEN_OPT_F ----------------------

11619:
11620: l_opt_id number(15);
11621: l_out_opt_result_id number(15);
11622: ---------------------------------------------------------------
11623: -- END OF BEN_OPT_F ----------------------
11624: ---------------------------------------------------------------
11625: ---------------------------------------------------------------
11626: -- START OF BEN_DSGN_RQMT_F ----------------------
11627: ---------------------------------------------------------------

Line 11768: -- START OF BEN_OPT_F ----------------------

11764:
11765: begin
11766: --
11767: ---------------------------------------------------------------
11768: -- START OF BEN_OPT_F ----------------------
11769: ---------------------------------------------------------------
11770:
11771: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
11772: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;

Line 11842: p_parent_entity_result_id => null, -- Hide BEN_OPT_F for HGrid

11838: p_copy_entity_result_id => l_copy_entity_result_id,
11839: p_copy_entity_txn_id => p_copy_entity_txn_id,
11840: p_result_type_cd => l_result_type_cd,
11841: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
11842: p_parent_entity_result_id => null, -- Hide BEN_OPT_F for HGrid
11843: p_number_of_copies => l_number_of_copies,
11844: p_table_alias => 'OPT',
11845: p_table_route_id => l_table_route_id,
11846: p_information1 => l_opt_rec.opt_id,

Line 12288: -- END OF BEN_OPT_F ----------------------

12284: ---------------------------------------------------------------
12285:
12286: end if;
12287: ---------------------------------------------------------------
12288: -- END OF BEN_OPT_F ----------------------
12289: ---------------------------------------------------------------
12290: --
12291: end create_opt_result ;
12292: --