DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_LOS_FCTR

Line 4194: -- START OF BEN_LOS_FCTR ----------------------

4190: ---------------------------------------------------------------
4191: -- END OF BEN_HRS_WKD_IN_PERD_FCTR ----------------------
4192: ---------------------------------------------------------------
4193: ---------------------------------------------------------------
4194: -- START OF BEN_LOS_FCTR ----------------------
4195: ---------------------------------------------------------------
4196: cursor c_lsf(c_los_fctr_id number,c_mirror_src_entity_result_id number,
4197: c_table_alias varchar2 ) is
4198: select lsf.*

Line 4199: from BEN_LOS_FCTR lsf

4195: ---------------------------------------------------------------
4196: cursor c_lsf(c_los_fctr_id number,c_mirror_src_entity_result_id number,
4197: c_table_alias varchar2 ) is
4198: select lsf.*
4199: from BEN_LOS_FCTR lsf
4200: where lsf.los_fctr_id = c_los_fctr_id
4201: -- and lsf.business_group_id = p_business_group_id
4202: and not exists (
4203: select /* */ null

Line 4210: -- and trt.where_clause = 'BEN_LOS_FCTR'

4206: where copy_entity_txn_id = p_copy_entity_txn_id
4207: -- and trt.table_route_id = cpe.table_route_id
4208: and ( -- c_mirror_src_entity_result_id is null or
4209: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
4210: -- and trt.where_clause = 'BEN_LOS_FCTR'
4211: and cpe.table_alias = c_table_alias
4212: and information1 = c_los_fctr_id
4213: -- and information4 = lsf.business_group_id
4214: );

Line 4218: -- END OF BEN_LOS_FCTR ----------------------

4214: );
4215: l_los_fctr_id number(15);
4216: l_out_lsf_result_id number(15);
4217: ---------------------------------------------------------------
4218: -- END OF BEN_LOS_FCTR ----------------------
4219: ---------------------------------------------------------------
4220: ---------------------------------------------------------------
4221: -- START OF BEN_PCT_FL_TM_FCTR ----------------------
4222: ---------------------------------------------------------------

Line 5109: -- START OF BEN_LOS_FCTR ----------------------

5105: end if;
5106: close c_object_exists;
5107: end if;
5108: ---------------------------------------------------------------
5109: -- START OF BEN_LOS_FCTR ----------------------
5110: ---------------------------------------------------------------
5111: l_mirror_src_entity_result_id := p_copy_entity_result_id ;
5112: --
5113: l_los_fctr_id := p_los_fctr_id ;

Line 5291: -- END OF BEN_LOS_FCTR ----------------------

5287:
5288: end loop;
5289: --
5290: ---------------------------------------------------------------
5291: -- END OF BEN_LOS_FCTR ----------------------
5292: ---------------------------------------------------------------
5293: end if;
5294: if p_pct_fl_tm_fctr_id is not null then
5295: