APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIGY_PRFL_RL_F

Line 1255: -- START OF BEN_ELIGY_PRFL_RL_F ----------------------

1251: ---------------------------------------------------------------
1252: -- END OF BEN_CNTNG_PRTN_ELIG_PRFL_F ----------------------
1253: ---------------------------------------------------------------
1254: ---------------------------------------------------------------
1255: -- START OF BEN_ELIGY_PRFL_RL_F ----------------------
1256: ---------------------------------------------------------------
1257: cursor c_erl_from_parent(c_ELIGY_PRFL_ID number) is
1258: select eligy_prfl_rl_id
1259: from BEN_ELIGY_PRFL_RL_F

Line 1259: from BEN_ELIGY_PRFL_RL_F

1255: -- START OF BEN_ELIGY_PRFL_RL_F ----------------------
1256: ---------------------------------------------------------------
1257: cursor c_erl_from_parent(c_ELIGY_PRFL_ID number) is
1258: select eligy_prfl_rl_id
1259: from BEN_ELIGY_PRFL_RL_F
1260: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
1261: --
1262: cursor c_erl(c_eligy_prfl_rl_id number,c_mirror_src_entity_result_id number ,
1263: c_table_alias varchar2 ) is

Line 1265: from BEN_ELIGY_PRFL_RL_F erl

1261: --
1262: cursor c_erl(c_eligy_prfl_rl_id number,c_mirror_src_entity_result_id number ,
1263: c_table_alias varchar2 ) is
1264: select erl.*
1265: from BEN_ELIGY_PRFL_RL_F erl
1266: where erl.eligy_prfl_rl_id = c_eligy_prfl_rl_id
1267: -- and erl.business_group_id = p_business_group_id
1268: and not exists (
1269: select /* */ null

Line 1276: -- and trt.where_clause = 'BEN_ELIGY_PRFL_RL_F'

1272: where copy_entity_txn_id = p_copy_entity_txn_id
1273: -- and trt.table_route_id = cpe.table_route_id
1274: and ( -- c_mirror_src_entity_result_id is null or
1275: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1276: -- and trt.where_clause = 'BEN_ELIGY_PRFL_RL_F'
1277: and cpe.table_alias = c_table_alias
1278: and information1 = c_eligy_prfl_rl_id
1279: -- and information4 = erl.business_group_id
1280: and information2 = erl.effective_start_date

Line 1286: -- END OF BEN_ELIGY_PRFL_RL_F ----------------------

1282: );
1283: l_eligy_prfl_rl_id number(15);
1284: l_out_erl_result_id number(15);
1285: ---------------------------------------------------------------
1286: -- END OF BEN_ELIGY_PRFL_RL_F ----------------------
1287: ---------------------------------------------------------------
1288: ---------------------------------------------------------------
1289: -- START OF BEN_ELIG_AGE_PRTE_F ----------------------
1290: ---------------------------------------------------------------

Line 4266: -- START OF BEN_ELIGY_PRFL_RL_F ----------------------

4262: ---------------------------------------------------------------
4263: -- END OF BEN_CNTNG_PRTN_ELIG_PRFL_F ----------------------
4264: ---------------------------------------------------------------
4265: ---------------------------------------------------------------
4266: -- START OF BEN_ELIGY_PRFL_RL_F ----------------------
4267: ---------------------------------------------------------------
4268: --
4269: for l_parent_rec in c_erl_from_parent(l_ELIGY_PRFL_ID) loop
4270: --

Line 4380: -- END OF BEN_ELIGY_PRFL_RL_F ----------------------

4376: end loop;
4377: --
4378: end loop;
4379: ---------------------------------------------------------------
4380: -- END OF BEN_ELIGY_PRFL_RL_F ----------------------
4381: ---------------------------------------------------------------
4382: ---------------------------------------------------------------
4383: -- START OF BEN_ELIG_AGE_PRTE_F ----------------------
4384: ---------------------------------------------------------------