eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_WV_PRTN_RSN_PL_F

Line 305: -- START OF BEN_WV_PRTN_RSN_PL_F ----------------------

301: ---------------------------------------------------------------
302: -- END OF BEN_VALD_RLSHP_FOR_REIMB_F ----------------------
303: ---------------------------------------------------------------
304: ---------------------------------------------------------------
305: -- START OF BEN_WV_PRTN_RSN_PL_F ----------------------
306: ---------------------------------------------------------------
307: cursor c_wpn_from_parent(c_PL_ID number) is
308: select wv_prtn_rsn_pl_id
309: from BEN_WV_PRTN_RSN_PL_F

Line 309: from BEN_WV_PRTN_RSN_PL_F

305: -- START OF BEN_WV_PRTN_RSN_PL_F ----------------------
306: ---------------------------------------------------------------
307: cursor c_wpn_from_parent(c_PL_ID number) is
308: select wv_prtn_rsn_pl_id
309: from BEN_WV_PRTN_RSN_PL_F
310: where PL_ID = c_PL_ID ;
311: --
312: cursor c_wpn(c_wv_prtn_rsn_pl_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
313: select wpn.*

Line 314: from BEN_WV_PRTN_RSN_PL_F wpn

310: where PL_ID = c_PL_ID ;
311: --
312: cursor c_wpn(c_wv_prtn_rsn_pl_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
313: select wpn.*
314: from BEN_WV_PRTN_RSN_PL_F wpn
315: where wpn.wv_prtn_rsn_pl_id = c_wv_prtn_rsn_pl_id
316: -- and wpn.business_group_id = p_business_group_id
317: and not exists (
318: select /*+ */ null

Line 325: -- and trt.where_clause = 'BEN_WV_PRTN_RSN_PL_F'

321: where copy_entity_txn_id = p_copy_entity_txn_id
322: -- and trt.table_route_id = cpe.table_route_id
323: and ( -- c_mirror_src_entity_result_id is null or
324: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
325: -- and trt.where_clause = 'BEN_WV_PRTN_RSN_PL_F'
326: and cpe.table_alias = c_table_alias
327: and information1 = c_wv_prtn_rsn_pl_id
328: -- and information4 = wpn.business_group_id
329: and information2 = wpn.effective_start_date

Line 335: -- END OF BEN_WV_PRTN_RSN_PL_F ----------------------

331: );
332:
333: l_out_wpn_result_id number(15);
334: ---------------------------------------------------------------
335: -- END OF BEN_WV_PRTN_RSN_PL_F ----------------------
336: ---------------------------------------------------------------
337:
338: ---------------------------------------------------------------
339: -- START OF BEN_BNFT_RSTRN_CTFN_F ----------------------

Line 3546: -- START OF BEN_WV_PRTN_RSN_PL_F ----------------------

3542: -- END OF BEN_VALD_RLSHP_FOR_REIMB_F ----------------------
3543: ---------------------------------------------------------------
3544:
3545: ---------------------------------------------------------------
3546: -- START OF BEN_WV_PRTN_RSN_PL_F ----------------------
3547: ---------------------------------------------------------------
3548: --
3549: --
3550: for l_parent_rec in c_wpn_from_parent(l_PL_ID) loop

Line 3756: -- END OF BEN_WV_PRTN_RSN_PL_F ----------------------

3752: -- END OF BEN_WV_PRTN_RSN_CTFN_PL_F ----------------------
3753: ---------------------------------------------------------------
3754: end loop;
3755: ---------------------------------------------------------------
3756: -- END OF BEN_WV_PRTN_RSN_PL_F ----------------------
3757: ---------------------------------------------------------------
3758:
3759: ---------------------------------------------------------------
3760: -- START OF BEN_BNFT_RSTRN_CTFN_F ----------------------