APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_BRGNG_UNIT_RT_F

Line 5881: -- START OF BEN_BRGNG_UNIT_RT_F ----------------------

5877: -- END OF BEN_BENFTS_GRP_RT_F ----------------------
5878: ---------------------------------------------------------------
5879:
5880: ---------------------------------------------------------------
5881: -- START OF BEN_BRGNG_UNIT_RT_F ----------------------
5882: ---------------------------------------------------------------
5883: cursor c_bur_from_parent(c_VRBL_RT_PRFL_ID number) is
5884: select brgng_unit_rt_id
5885: from BEN_BRGNG_UNIT_RT_F

Line 5885: from BEN_BRGNG_UNIT_RT_F

5881: -- START OF BEN_BRGNG_UNIT_RT_F ----------------------
5882: ---------------------------------------------------------------
5883: cursor c_bur_from_parent(c_VRBL_RT_PRFL_ID number) is
5884: select brgng_unit_rt_id
5885: from BEN_BRGNG_UNIT_RT_F
5886: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
5887: --
5888: cursor c_bur(c_brgng_unit_rt_id number,c_mirror_src_entity_result_id number,
5889: c_table_alias varchar2 ) is

Line 5891: from BEN_BRGNG_UNIT_RT_F bur

5887: --
5888: cursor c_bur(c_brgng_unit_rt_id number,c_mirror_src_entity_result_id number,
5889: c_table_alias varchar2 ) is
5890: select bur.*
5891: from BEN_BRGNG_UNIT_RT_F bur
5892: where bur.brgng_unit_rt_id = c_brgng_unit_rt_id
5893: -- and bur.business_group_id = p_business_group_id
5894: and not exists (
5895: select /* */ null

Line 5902: -- and trt.where_clause = 'BEN_BRGNG_UNIT_RT_F'

5898: where copy_entity_txn_id = p_copy_entity_txn_id
5899: -- and trt.table_route_id = cpe.table_route_id
5900: and ( -- c_mirror_src_entity_result_id is null or
5901: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
5902: -- and trt.where_clause = 'BEN_BRGNG_UNIT_RT_F'
5903: and cpe.table_alias = c_table_alias
5904: and information1 = c_brgng_unit_rt_id
5905: -- and information4 = bur.business_group_id
5906: and information2 = bur.effective_start_date

Line 5911: -- END OF BEN_BRGNG_UNIT_RT_F ----------------------

5907: and information3 = bur.effective_end_date);
5908: l_brgng_unit_rt_id number(15);
5909: l_out_bur_result_id number(15);
5910: ---------------------------------------------------------------
5911: -- END OF BEN_BRGNG_UNIT_RT_F ----------------------
5912: ---------------------------------------------------------------
5913: ---------------------------------------------------------------
5914: -- START OF BEN_CMBN_AGE_LOS_RT_F ----------------------
5915: ---------------------------------------------------------------

Line 8694: -- START OF BEN_BRGNG_UNIT_RT_F ----------------------

8690: -- END OF BEN_BENFTS_GRP_RT_F ----------------------
8691: ---------------------------------------------------------------
8692:
8693: ---------------------------------------------------------------
8694: -- START OF BEN_BRGNG_UNIT_RT_F ----------------------
8695: ---------------------------------------------------------------
8696: --
8697: for l_parent_rec in c_bur_from_parent(l_VRBL_RT_PRFL_ID) loop
8698: --

Line 8794: -- END OF BEN_BRGNG_UNIT_RT_F ----------------------

8790: end loop;
8791: --
8792: end loop;
8793: ---------------------------------------------------------------
8794: -- END OF BEN_BRGNG_UNIT_RT_F ----------------------
8795: ---------------------------------------------------------------
8796: ---------------------------------------------------------------
8797: -- START OF BEN_CMBN_AGE_LOS_RT_F ----------------------
8798: ---------------------------------------------------------------