APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_COMP_LVL_FCTR

Line 4114: -- START OF BEN_COMP_LVL_FCTR ----------------------

4110: ---------------------------------------------------------------
4111: -- END OF BEN_CMBN_AGE_LOS_FCTR ----------------------
4112: ---------------------------------------------------------------
4113: ---------------------------------------------------------------
4114: -- START OF BEN_COMP_LVL_FCTR ----------------------
4115: ---------------------------------------------------------------
4116: cursor c_clf(c_comp_lvl_fctr_id number,c_mirror_src_entity_result_id number,
4117: c_table_alias varchar2 ) is
4118: select clf.*

Line 4119: from BEN_COMP_LVL_FCTR clf

4115: ---------------------------------------------------------------
4116: cursor c_clf(c_comp_lvl_fctr_id number,c_mirror_src_entity_result_id number,
4117: c_table_alias varchar2 ) is
4118: select clf.*
4119: from BEN_COMP_LVL_FCTR clf
4120: where clf.comp_lvl_fctr_id = c_comp_lvl_fctr_id
4121: -- and clf.business_group_id = p_business_group_id
4122: and not exists (
4123: select /* */ null

Line 4130: -- and trt.where_clause = 'BEN_COMP_LVL_FCTR'

4126: where copy_entity_txn_id = p_copy_entity_txn_id
4127: -- and trt.table_route_id = cpe.table_route_id
4128: and ( -- c_mirror_src_entity_result_id is null or
4129: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
4130: -- and trt.where_clause = 'BEN_COMP_LVL_FCTR'
4131: and cpe.table_alias = c_table_alias
4132: and information1 = c_comp_lvl_fctr_id
4133: -- and information4 = clf.business_group_id
4134: );

Line 4145: -- and trt.where_clause = 'BEN_COMP_LVL_FCTR'

4141: -- pqh_table_route trt
4142: where copy_entity_txn_id = p_copy_entity_txn_id
4143: -- and trt.table_route_id = cpe.table_route_id
4144: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
4145: -- and trt.where_clause = 'BEN_COMP_LVL_FCTR'
4146: and cpe.table_alias = c_table_alias
4147: and information1 = c_comp_lvl_fctr_id
4148: -- and information4 = p_business_group_id
4149: ;

Line 4151: -- END OF BEN_COMP_LVL_FCTR ----------------------

4147: and information1 = c_comp_lvl_fctr_id
4148: -- and information4 = p_business_group_id
4149: ;
4150: ---------------------------------------------------------------
4151: -- END OF BEN_COMP_LVL_FCTR ----------------------
4152: ---------------------------------------------------------------
4153: ---------------------------------------------------------------
4154: -- START OF BEN_HRS_WKD_IN_PERD_FCTR ----------------------
4155: ---------------------------------------------------------------

Line 4624: -- START OF BEN_COMP_LVL_FCTR ----------------------

4620: end if;
4621: close c_object_exists;
4622: end if;
4623: ---------------------------------------------------------------
4624: -- START OF BEN_COMP_LVL_FCTR ----------------------
4625: ---------------------------------------------------------------
4626: --
4627: l_mirror_src_entity_result_id := p_copy_entity_result_id ;
4628: --

Line 4853: -- END OF BEN_COMP_LVL_FCTR ----------------------

4849: ,p_effective_date => p_effective_date
4850: );
4851: end loop;
4852: ---------------------------------------------------------------
4853: -- END OF BEN_COMP_LVL_FCTR ----------------------
4854: ---------------------------------------------------------------
4855: end if;
4856: --
4857: if p_hrs_wkd_in_perd_fctr_id is not null then