APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_LVG_RSN_RT_F

Line 6488: -- START OF BEN_LVG_RSN_RT_F ----------------------

6484: ---------------------------------------------------------------
6485: -- END OF BEN_LOS_RT_F ----------------------
6486: ---------------------------------------------------------------
6487: ---------------------------------------------------------------
6488: -- START OF BEN_LVG_RSN_RT_F ----------------------
6489: ---------------------------------------------------------------
6490: cursor c_lrn_from_parent(c_VRBL_RT_PRFL_ID number) is
6491: select lvg_rsn_rt_id
6492: from BEN_LVG_RSN_RT_F

Line 6492: from BEN_LVG_RSN_RT_F

6488: -- START OF BEN_LVG_RSN_RT_F ----------------------
6489: ---------------------------------------------------------------
6490: cursor c_lrn_from_parent(c_VRBL_RT_PRFL_ID number) is
6491: select lvg_rsn_rt_id
6492: from BEN_LVG_RSN_RT_F
6493: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6494: --
6495: cursor c_lrn(c_lvg_rsn_rt_id number,c_mirror_src_entity_result_id number,
6496: c_table_alias varchar2 ) is

Line 6498: from BEN_LVG_RSN_RT_F lrn

6494: --
6495: cursor c_lrn(c_lvg_rsn_rt_id number,c_mirror_src_entity_result_id number,
6496: c_table_alias varchar2 ) is
6497: select lrn.*
6498: from BEN_LVG_RSN_RT_F lrn
6499: where lrn.lvg_rsn_rt_id = c_lvg_rsn_rt_id
6500: -- and lrn.business_group_id = p_business_group_id
6501: and not exists (
6502: select /* */ null

Line 6509: -- and trt.where_clause = 'BEN_LVG_RSN_RT_F'

6505: where copy_entity_txn_id = p_copy_entity_txn_id
6506: -- and trt.table_route_id = cpe.table_route_id
6507: and ( -- c_mirror_src_entity_result_id is null or
6508: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6509: -- and trt.where_clause = 'BEN_LVG_RSN_RT_F'
6510: and cpe.table_alias = c_table_alias
6511: and information1 = c_lvg_rsn_rt_id
6512: -- and information4 = lrn.business_group_id
6513: and information2 = lrn.effective_start_date

Line 6518: -- END OF BEN_LVG_RSN_RT_F ----------------------

6514: and information3 = lrn.effective_end_date);
6515: l_lvg_rsn_rt_id number(15);
6516: l_out_lrn_result_id number(15);
6517: ---------------------------------------------------------------
6518: -- END OF BEN_LVG_RSN_RT_F ----------------------
6519: ---------------------------------------------------------------
6520: ---------------------------------------------------------------
6521: -- START OF BEN_ORG_UNIT_RT_F ----------------------
6522: ---------------------------------------------------------------

Line 10408: -- START OF BEN_LVG_RSN_RT_F ----------------------

10404: ---------------------------------------------------------------
10405: -- END OF BEN_LOS_RT_F ----------------------
10406: ---------------------------------------------------------------
10407: ---------------------------------------------------------------
10408: -- START OF BEN_LVG_RSN_RT_F ----------------------
10409: ---------------------------------------------------------------
10410: --
10411: for l_parent_rec in c_lrn_from_parent(l_VRBL_RT_PRFL_ID) loop
10412: --

Line 10506: -- END OF BEN_LVG_RSN_RT_F ----------------------

10502: end loop;
10503: --
10504: end loop;
10505: ---------------------------------------------------------------
10506: -- END OF BEN_LVG_RSN_RT_F ----------------------
10507: ---------------------------------------------------------------
10508: ---------------------------------------------------------------
10509: -- START OF BEN_ORG_UNIT_RT_F ----------------------
10510: ---------------------------------------------------------------