APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_OIPL_F

Line 1114: -- START OF BEN_OIPL_F ----------------------

1110: ---------------------------------------------------------------
1111: -- END OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
1112: ---------------------------------------------------------------
1113: ---------------------------------------------------------------
1114: -- START OF BEN_OIPL_F ----------------------
1115: ---------------------------------------------------------------
1116: cursor c_cop1_from_parent(c_PL_ID number) is
1117: select distinct oipl_id
1118: from BEN_OIPL_F

Line 1118: from BEN_OIPL_F

1114: -- START OF BEN_OIPL_F ----------------------
1115: ---------------------------------------------------------------
1116: cursor c_cop1_from_parent(c_PL_ID number) is
1117: select distinct oipl_id
1118: from BEN_OIPL_F
1119: where PL_ID = c_PL_ID ;
1120: ---------------------------------------------------------------
1121: ---------------------------------------------------------------
1122: -- START OF BEN_PL_REGN_F ----------------------

Line 10094: -- START OF BEN_OIPL_F ----------------------

10090: -- from pqh_table_route trt
10091: -- where trt.table_alias = c_parent_table_alias;
10092: --
10093: ---------------------------------------------------------------
10094: -- START OF BEN_OIPL_F ----------------------
10095: ---------------------------------------------------------------
10096: cursor c_cop1(c_oipl_id number,c_mirror_src_entity_result_id number,
10097: c_table_alias varchar2) is
10098: select cop.*

Line 10099: from BEN_OIPL_F cop

10095: ---------------------------------------------------------------
10096: cursor c_cop1(c_oipl_id number,c_mirror_src_entity_result_id number,
10097: c_table_alias varchar2) is
10098: select cop.*
10099: from BEN_OIPL_F cop
10100: where cop.oipl_id = c_oipl_id
10101: -- and cop.business_group_id = p_business_group_id
10102: and not exists (
10103: select /*+ */ null

Line 10110: -- and trt.where_clause = 'BEN_OIPL_F'

10106: where copy_entity_txn_id = p_copy_entity_txn_id
10107: -- and trt.table_route_id = cpe.table_route_id
10108: and ( -- c_mirror_src_entity_result_id is null or
10109: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
10110: -- and trt.where_clause = 'BEN_OIPL_F'
10111: and cpe.table_alias = c_table_alias
10112: and information1 = c_oipl_id
10113: -- and information4 = cop.business_group_id
10114: and information2 = cop.effective_start_date

Line 10120: -- END OF BEN_OIPL_F ----------------------

10116: );
10117: l_oipl_id number(15);
10118: l_out_cop_result_id number(15);
10119: ---------------------------------------------------------------
10120: -- END OF BEN_OIPL_F ----------------------
10121: ---------------------------------------------------------------
10122: ---------------------------------------------------------------
10123: -- START OF BEN_DSGN_RQMT_F ----------------------
10124: ---------------------------------------------------------------

Line 10377: from BEN_OIPL_F

10373: ---------------------------------------------------------------
10374:
10375: cursor c_opt1_from_parent(c_OIPL_ID number) is
10376: select distinct opt_id
10377: from BEN_OIPL_F
10378: where OIPL_ID = c_OIPL_ID ;
10379:
10380: l_mirror_src_entity_result_id number;
10381: l_parent_entity_result_id number;

Line 10397: -- START OF BEN_OIPL_F ----------------------

10393: --
10394: begin
10395: --
10396: ---------------------------------------------------------------
10397: -- START OF BEN_OIPL_F ----------------------
10398: ---------------------------------------------------------------
10399:
10400: l_mirror_src_entity_result_id := p_copy_entity_result_id;
10401: l_parent_entity_result_id := p_parent_entity_result_id;

Line 11534: -- END OF BEN_OIPL_F ----------------------

11530: end loop;
11531:
11532: end if;
11533: ---------------------------------------------------------------
11534: -- END OF BEN_OIPL_F ----------------------
11535: ---------------------------------------------------------------
11536: --
11537: end create_oipl_result ;
11538: --