APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_GNDR_RT_F

Line 6128: -- START OF BEN_GNDR_RT_F ----------------------

6124: ---------------------------------------------------------------
6125: -- END OF BEN_FL_TM_PT_TM_RT_F ----------------------
6126: ---------------------------------------------------------------
6127: ---------------------------------------------------------------
6128: -- START OF BEN_GNDR_RT_F ----------------------
6129: ---------------------------------------------------------------
6130: cursor c_gnr_from_parent(c_VRBL_RT_PRFL_ID number) is
6131: select gndr_rt_id
6132: from BEN_GNDR_RT_F

Line 6132: from BEN_GNDR_RT_F

6128: -- START OF BEN_GNDR_RT_F ----------------------
6129: ---------------------------------------------------------------
6130: cursor c_gnr_from_parent(c_VRBL_RT_PRFL_ID number) is
6131: select gndr_rt_id
6132: from BEN_GNDR_RT_F
6133: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6134: --
6135: cursor c_gnr(c_gndr_rt_id number,c_mirror_src_entity_result_id number,
6136: c_table_alias varchar2 ) is

Line 6138: from BEN_GNDR_RT_F gnr

6134: --
6135: cursor c_gnr(c_gndr_rt_id number,c_mirror_src_entity_result_id number,
6136: c_table_alias varchar2 ) is
6137: select gnr.*
6138: from BEN_GNDR_RT_F gnr
6139: where gnr.gndr_rt_id = c_gndr_rt_id
6140: -- and gnr.business_group_id = p_business_group_id
6141: and not exists (
6142: select /* */ null

Line 6149: -- and trt.where_clause = 'BEN_GNDR_RT_F'

6145: where copy_entity_txn_id = p_copy_entity_txn_id
6146: -- and trt.table_route_id = cpe.table_route_id
6147: and ( -- c_mirror_src_entity_result_id is null or
6148: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6149: -- and trt.where_clause = 'BEN_GNDR_RT_F'
6150: and cpe.table_alias = c_table_alias
6151: and information1 = c_gndr_rt_id
6152: -- and information4 = gnr.business_group_id
6153: and information2 = gnr.effective_start_date

Line 6158: -- END OF BEN_GNDR_RT_F ----------------------

6154: and information3 = gnr.effective_end_date);
6155: l_gndr_rt_id number(15);
6156: l_out_gnr_result_id number(15);
6157: ---------------------------------------------------------------
6158: -- END OF BEN_GNDR_RT_F ----------------------
6159: ---------------------------------------------------------------
6160: ---------------------------------------------------------------
6161: -- START OF BEN_GRADE_RT_F ----------------------
6162: ---------------------------------------------------------------

Line 9385: -- START OF BEN_GNDR_RT_F ----------------------

9381: ---------------------------------------------------------------
9382: -- END OF BEN_FL_TM_PT_TM_RT_F ----------------------
9383: ---------------------------------------------------------------
9384: ---------------------------------------------------------------
9385: -- START OF BEN_GNDR_RT_F ----------------------
9386: ---------------------------------------------------------------
9387: --
9388: for l_parent_rec in c_gnr_from_parent(l_VRBL_RT_PRFL_ID) loop
9389: --

Line 9484: -- END OF BEN_GNDR_RT_F ----------------------

9480: end loop;
9481: --
9482: end loop;
9483: ---------------------------------------------------------------
9484: -- END OF BEN_GNDR_RT_F ----------------------
9485: ---------------------------------------------------------------
9486: ---------------------------------------------------------------
9487: -- START OF BEN_GRADE_RT_F ----------------------
9488: ---------------------------------------------------------------