APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_AGE_RT_F

Line 5745: -- START OF BEN_AGE_RT_F ----------------------

5741: ---------------------------------------------------------------
5742: -- END OF BEN_VRBL_RT_PRFL_F ----------------------
5743: ---------------------------------------------------------------
5744: ---------------------------------------------------------------
5745: -- START OF BEN_AGE_RT_F ----------------------
5746: ---------------------------------------------------------------
5747: cursor c_art_from_parent(c_VRBL_RT_PRFL_ID number) is
5748: select distinct age_rt_id
5749: from BEN_AGE_RT_F

Line 5749: from BEN_AGE_RT_F

5745: -- START OF BEN_AGE_RT_F ----------------------
5746: ---------------------------------------------------------------
5747: cursor c_art_from_parent(c_VRBL_RT_PRFL_ID number) is
5748: select distinct age_rt_id
5749: from BEN_AGE_RT_F
5750: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
5751: --
5752: cursor c_art(c_age_rt_id number,c_mirror_src_entity_result_id number,
5753: c_table_alias varchar2 ) is

Line 5755: from BEN_AGE_RT_F art

5751: --
5752: cursor c_art(c_age_rt_id number,c_mirror_src_entity_result_id number,
5753: c_table_alias varchar2 ) is
5754: select art.*
5755: from BEN_AGE_RT_F art
5756: where art.age_rt_id = c_age_rt_id
5757: -- and art.business_group_id = p_business_group_id
5758: and not exists (
5759: select /* */ null

Line 5766: -- and trt.where_clause = 'BEN_AGE_RT_F'

5762: where copy_entity_txn_id = p_copy_entity_txn_id
5763: -- and trt.table_route_id = cpe.table_route_id
5764: and ( -- c_mirror_src_entity_result_id is null or
5765: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
5766: -- and trt.where_clause = 'BEN_AGE_RT_F'
5767: and cpe.table_alias = c_table_alias
5768: and information1 = c_age_rt_id
5769: -- and information4 = art.business_group_id
5770: and information2 = art.effective_start_date

Line 5783: -- and trt.where_clause = 'BEN_AGE_RT_F'

5779: -- pqh_table_route trt
5780: where copy_entity_txn_id = p_copy_entity_txn_id
5781: -- and trt.table_route_id = cpe.table_route_id
5782: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
5783: -- and trt.where_clause = 'BEN_AGE_RT_F'
5784: and cpe.table_alias = c_table_alias
5785: and information1 = c_age_rt_id
5786: -- and information4 = p_business_group_id
5787: ;

Line 5789: -- END OF BEN_AGE_RT_F ----------------------

5785: and information1 = c_age_rt_id
5786: -- and information4 = p_business_group_id
5787: ;
5788: ---------------------------------------------------------------
5789: -- END OF BEN_AGE_RT_F ----------------------
5790: ---------------------------------------------------------------
5791: ---------------------------------------------------------------
5792: -- START OF BEN_ASNT_SET_RT_F ----------------------
5793: ---------------------------------------------------------------

Line 8318: -- START OF BEN_AGE_RT_F ----------------------

8314: );
8315:
8316: --
8317: ---------------------------------------------------------------
8318: -- START OF BEN_AGE_RT_F ----------------------
8319: ---------------------------------------------------------------
8320: --
8321: for l_parent_rec in c_art_from_parent(l_VRBL_RT_PRFL_ID) loop
8322: --

Line 8436: -- END OF BEN_AGE_RT_F ----------------------

8432: end loop;
8433: --
8434: end loop;
8435: ---------------------------------------------------------------
8436: -- END OF BEN_AGE_RT_F ----------------------
8437: ---------------------------------------------------------------
8438: ---------------------------------------------------------------
8439: -- START OF BEN_ASNT_SET_RT_F ----------------------
8440: ---------------------------------------------------------------