DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_DSBLD_RT_F

Line 6005: -- START OF BEN_DSBLD_RT_F ----------------------

6001: ---------------------------------------------------------------
6002: -- END OF BEN_COMP_LVL_RT_F ----------------------
6003: ---------------------------------------------------------------
6004: ---------------------------------------------------------------
6005: -- START OF BEN_DSBLD_RT_F ----------------------
6006: ---------------------------------------------------------------
6007: cursor c_dbr_from_parent(c_VRBL_RT_PRFL_ID number) is
6008: select dsbld_rt_id
6009: from BEN_DSBLD_RT_F

Line 6009: from BEN_DSBLD_RT_F

6005: -- START OF BEN_DSBLD_RT_F ----------------------
6006: ---------------------------------------------------------------
6007: cursor c_dbr_from_parent(c_VRBL_RT_PRFL_ID number) is
6008: select dsbld_rt_id
6009: from BEN_DSBLD_RT_F
6010: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6011: --
6012: cursor c_dbr(c_dsbld_rt_id number,c_mirror_src_entity_result_id number,
6013: c_table_alias varchar2 ) is

Line 6015: from BEN_DSBLD_RT_F dbr

6011: --
6012: cursor c_dbr(c_dsbld_rt_id number,c_mirror_src_entity_result_id number,
6013: c_table_alias varchar2 ) is
6014: select dbr.*
6015: from BEN_DSBLD_RT_F dbr
6016: where dbr.dsbld_rt_id = c_dsbld_rt_id
6017: -- and dbr.business_group_id = p_business_group_id
6018: and not exists (
6019: select /* */ null

Line 6026: -- and trt.where_clause = 'BEN_DSBLD_RT_F'

6022: where copy_entity_txn_id = p_copy_entity_txn_id
6023: -- and trt.table_route_id = cpe.table_route_id
6024: and ( -- c_mirror_src_entity_result_id is null or
6025: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6026: -- and trt.where_clause = 'BEN_DSBLD_RT_F'
6027: and cpe.table_alias = c_table_alias
6028: and information1 = c_dsbld_rt_id
6029: -- and information4 = dbr.business_group_id
6030: and information2 = dbr.effective_start_date

Line 6035: -- END OF BEN_DSBLD_RT_F ----------------------

6031: and information3 = dbr.effective_end_date);
6032: l_dsbld_rt_id number(15);
6033: l_out_dbr_result_id number(15);
6034: ---------------------------------------------------------------
6035: -- END OF BEN_DSBLD_RT_F ----------------------
6036: ---------------------------------------------------------------
6037: ---------------------------------------------------------------
6038: -- START OF BEN_EE_STAT_RT_F ----------------------
6039: ---------------------------------------------------------------

Line 9041: -- START OF BEN_DSBLD_RT_F ----------------------

9037: ---------------------------------------------------------------
9038: -- END OF BEN_COMP_LVL_RT_F ----------------------
9039: ---------------------------------------------------------------
9040: ---------------------------------------------------------------
9041: -- START OF BEN_DSBLD_RT_F ----------------------
9042: ---------------------------------------------------------------
9043: --
9044: for l_parent_rec in c_dbr_from_parent(l_VRBL_RT_PRFL_ID) loop
9045: --

Line 9140: -- END OF BEN_DSBLD_RT_F ----------------------

9136: end loop;
9137: --
9138: end loop;
9139: ---------------------------------------------------------------
9140: -- END OF BEN_DSBLD_RT_F ----------------------
9141: ---------------------------------------------------------------
9142: ---------------------------------------------------------------
9143: -- START OF BEN_EE_STAT_RT_F ----------------------
9144: ---------------------------------------------------------------