APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIGY_PRFL_F

Line 1190: -- START OF BEN_ELIGY_PRFL_F ----------------------

1186: -- trt.table_alias = c_parent_table_alias ;
1187: ---
1188:
1189: ---------------------------------------------------------------
1190: -- START OF BEN_ELIGY_PRFL_F ----------------------
1191: ---------------------------------------------------------------
1192:
1193: --
1194: cursor c_elp(c_eligy_prfl_id number,c_mirror_src_entity_result_id number ,

Line 1197: from BEN_ELIGY_PRFL_F elp

1193: --
1194: cursor c_elp(c_eligy_prfl_id number,c_mirror_src_entity_result_id number ,
1195: c_table_alias varchar2 ) is
1196: select elp.*
1197: from BEN_ELIGY_PRFL_F elp
1198: where elp.eligy_prfl_id = c_eligy_prfl_id
1199: -- and elp.business_group_id = p_business_group_id
1200: and not exists (
1201: select /* */ null

Line 1208: -- and trt.where_clause = 'BEN_ELIGY_PRFL_F'

1204: where copy_entity_txn_id = p_copy_entity_txn_id
1205: -- and trt.table_route_id = cpe.table_route_id
1206: and ( -- c_mirror_src_entity_result_id is null or
1207: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1208: -- and trt.where_clause = 'BEN_ELIGY_PRFL_F'
1209: and cpe.table_alias = c_table_alias
1210: and information1 = c_eligy_prfl_id
1211: -- and information4 = elp.business_group_id
1212: and information2 = elp.effective_start_date

Line 1218: -- END OF BEN_ELIGY_PRFL_F ----------------------

1214: );
1215: l_eligy_prfl_id number(15);
1216: l_out_elp_result_id number(15);
1217: ---------------------------------------------------------------
1218: -- END OF BEN_ELIGY_PRFL_F ----------------------
1219: ---------------------------------------------------------------
1220: ---------------------------------------------------------------
1221: -- START OF BEN_CNTNG_PRTN_ELIG_PRFL_F ----------------------
1222: ---------------------------------------------------------------

Line 3931: -- START OF BEN_ELIGY_PRFL_F ----------------------

3927: l_number_of_copies number(15);
3928: begin
3929:
3930: ---------------------------------------------------------------
3931: -- START OF BEN_ELIGY_PRFL_F ----------------------
3932: ---------------------------------------------------------------
3933:
3934: -- Bug 5059695 : Fetch the transaction category
3935: if(ben_plan_design_elpro_module.g_copy_entity_txn_id <> p_copy_entity_txn_id) then

Line 12196: -- END OF BEN_ELIGY_PRFL_F ----------------------

12192: ---------------------------------------------------------------
12193:
12194: end if;
12195: ---------------------------------------------------------------
12196: -- END OF BEN_ELIGY_PRFL_F ----------------------
12197: ---------------------------------------------------------------
12198:
12199: end;
12200: