DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_HRS_WKD_IN_PERD_FCTR

Line 4154: -- START OF BEN_HRS_WKD_IN_PERD_FCTR ----------------------

4150: ---------------------------------------------------------------
4151: -- END OF BEN_COMP_LVL_FCTR ----------------------
4152: ---------------------------------------------------------------
4153: ---------------------------------------------------------------
4154: -- START OF BEN_HRS_WKD_IN_PERD_FCTR ----------------------
4155: ---------------------------------------------------------------
4156: cursor c_hwf(c_hrs_wkd_in_perd_fctr_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
4157: select hwf.*
4158: from BEN_HRS_WKD_IN_PERD_FCTR hwf

Line 4158: from BEN_HRS_WKD_IN_PERD_FCTR hwf

4154: -- START OF BEN_HRS_WKD_IN_PERD_FCTR ----------------------
4155: ---------------------------------------------------------------
4156: cursor c_hwf(c_hrs_wkd_in_perd_fctr_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
4157: select hwf.*
4158: from BEN_HRS_WKD_IN_PERD_FCTR hwf
4159: where hwf.hrs_wkd_in_perd_fctr_id = c_hrs_wkd_in_perd_fctr_id
4160: -- and hwf.business_group_id = p_business_group_id
4161: and not exists (
4162: select /* */ null

Line 4169: -- and trt.where_clause = 'BEN_HRS_WKD_IN_PERD_FCTR'

4165: where copy_entity_txn_id = p_copy_entity_txn_id
4166: -- and trt.table_route_id = cpe.table_route_id
4167: and ( -- c_mirror_src_entity_result_id is null or
4168: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
4169: -- and trt.where_clause = 'BEN_HRS_WKD_IN_PERD_FCTR'
4170: and cpe.table_alias = c_table_alias
4171: and information1 = c_hrs_wkd_in_perd_fctr_id
4172: -- and information4 = hwf.business_group_id
4173: );

Line 4185: -- and trt.where_clause = 'BEN_HRS_WKD_IN_PERD_FCTR'

4181: -- pqh_table_route trt
4182: where copy_entity_txn_id = p_copy_entity_txn_id
4183: -- and trt.table_route_id = cpe.table_route_id
4184: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
4185: -- and trt.where_clause = 'BEN_HRS_WKD_IN_PERD_FCTR'
4186: and cpe.table_alias = c_table_alias
4187: and information1 = c_hrs_wkd_in_perd_fctr_id
4188: -- and information4 = p_business_group_id
4189: ;

Line 4191: -- END OF BEN_HRS_WKD_IN_PERD_FCTR ----------------------

4187: and information1 = c_hrs_wkd_in_perd_fctr_id
4188: -- and information4 = p_business_group_id
4189: ;
4190: ---------------------------------------------------------------
4191: -- END OF BEN_HRS_WKD_IN_PERD_FCTR ----------------------
4192: ---------------------------------------------------------------
4193: ---------------------------------------------------------------
4194: -- START OF BEN_LOS_FCTR ----------------------
4195: ---------------------------------------------------------------

Line 4869: -- START OF BEN_HRS_WKD_IN_PERD_FCTR ----------------------

4865: end if;
4866: close c_object_exists;
4867: end if;
4868: ---------------------------------------------------------------
4869: -- START OF BEN_HRS_WKD_IN_PERD_FCTR ----------------------
4870: ---------------------------------------------------------------
4871: --
4872: l_mirror_src_entity_result_id := p_copy_entity_result_id ;
4873: --

Line 5093: -- END OF BEN_HRS_WKD_IN_PERD_FCTR ----------------------

5089: ,p_effective_date => p_effective_date
5090: );
5091: end loop;
5092: ---------------------------------------------------------------
5093: -- END OF BEN_HRS_WKD_IN_PERD_FCTR ----------------------
5094: ---------------------------------------------------------------
5095: end if;
5096: --
5097: if p_los_fctr_id is not null then