APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_CNTNG_PRTN_ELIG_PRFL_F

Line 1221: -- START OF BEN_CNTNG_PRTN_ELIG_PRFL_F ----------------------

1217: ---------------------------------------------------------------
1218: -- END OF BEN_ELIGY_PRFL_F ----------------------
1219: ---------------------------------------------------------------
1220: ---------------------------------------------------------------
1221: -- START OF BEN_CNTNG_PRTN_ELIG_PRFL_F ----------------------
1222: ---------------------------------------------------------------
1223: cursor c_cgp_from_parent(c_ELIGY_PRFL_ID number) is
1224: select cntng_prtn_elig_prfl_id
1225: from BEN_CNTNG_PRTN_ELIG_PRFL_F

Line 1225: from BEN_CNTNG_PRTN_ELIG_PRFL_F

1221: -- START OF BEN_CNTNG_PRTN_ELIG_PRFL_F ----------------------
1222: ---------------------------------------------------------------
1223: cursor c_cgp_from_parent(c_ELIGY_PRFL_ID number) is
1224: select cntng_prtn_elig_prfl_id
1225: from BEN_CNTNG_PRTN_ELIG_PRFL_F
1226: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
1227: --
1228: cursor c_cgp(c_cntng_prtn_elig_prfl_id number,c_mirror_src_entity_result_id number ,
1229: c_table_alias varchar2 ) is

Line 1231: from BEN_CNTNG_PRTN_ELIG_PRFL_F cgp

1227: --
1228: cursor c_cgp(c_cntng_prtn_elig_prfl_id number,c_mirror_src_entity_result_id number ,
1229: c_table_alias varchar2 ) is
1230: select cgp.*
1231: from BEN_CNTNG_PRTN_ELIG_PRFL_F cgp
1232: where cgp.cntng_prtn_elig_prfl_id = c_cntng_prtn_elig_prfl_id
1233: -- and cgp.business_group_id = p_business_group_id
1234: and not exists (
1235: select /* */ null

Line 1242: -- and trt.where_clause = 'BEN_CNTNG_PRTN_ELIG_PRFL_F'

1238: where copy_entity_txn_id = p_copy_entity_txn_id
1239: -- and trt.table_route_id = cpe.table_route_id
1240: and ( -- c_mirror_src_entity_result_id is null or
1241: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1242: -- and trt.where_clause = 'BEN_CNTNG_PRTN_ELIG_PRFL_F'
1243: and cpe.table_alias = c_table_alias
1244: and information1 = c_cntng_prtn_elig_prfl_id
1245: -- and information4 = cgp.business_group_id
1246: and information2 = cgp.effective_start_date

Line 1252: -- END OF BEN_CNTNG_PRTN_ELIG_PRFL_F ----------------------

1248: );
1249: l_cntng_prtn_elig_prfl_id number(15);
1250: l_out_cgp_result_id number(15);
1251: ---------------------------------------------------------------
1252: -- END OF BEN_CNTNG_PRTN_ELIG_PRFL_F ----------------------
1253: ---------------------------------------------------------------
1254: ---------------------------------------------------------------
1255: -- START OF BEN_ELIGY_PRFL_RL_F ----------------------
1256: ---------------------------------------------------------------

Line 4147: -- START OF BEN_CNTNG_PRTN_ELIG_PRFL_F ----------------------

4143:
4144: if l_out_elp_result_id is not null then
4145: --
4146: ---------------------------------------------------------------
4147: -- START OF BEN_CNTNG_PRTN_ELIG_PRFL_F ----------------------
4148: ---------------------------------------------------------------
4149: --
4150: for l_parent_rec in c_cgp_from_parent(l_ELIGY_PRFL_ID) loop
4151: --

Line 4263: -- END OF BEN_CNTNG_PRTN_ELIG_PRFL_F ----------------------

4259: end loop;
4260: --
4261: end loop;
4262: ---------------------------------------------------------------
4263: -- END OF BEN_CNTNG_PRTN_ELIG_PRFL_F ----------------------
4264: ---------------------------------------------------------------
4265: ---------------------------------------------------------------
4266: -- START OF BEN_ELIGY_PRFL_RL_F ----------------------
4267: ---------------------------------------------------------------