APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_WK_LOC_RT_F

Line 7112: -- START OF BEN_WK_LOC_RT_F ----------------------

7108: ---------------------------------------------------------------
7109: -- END OF BEN_VRBL_RT_PRFL_RL_F ----------------------
7110: ---------------------------------------------------------------
7111: ---------------------------------------------------------------
7112: -- START OF BEN_WK_LOC_RT_F ----------------------
7113: ---------------------------------------------------------------
7114: cursor c_wlr_from_parent(c_VRBL_RT_PRFL_ID number) is
7115: select wk_loc_rt_id
7116: from BEN_WK_LOC_RT_F

Line 7116: from BEN_WK_LOC_RT_F

7112: -- START OF BEN_WK_LOC_RT_F ----------------------
7113: ---------------------------------------------------------------
7114: cursor c_wlr_from_parent(c_VRBL_RT_PRFL_ID number) is
7115: select wk_loc_rt_id
7116: from BEN_WK_LOC_RT_F
7117: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7118: --
7119: cursor c_wlr(c_wk_loc_rt_id number,c_mirror_src_entity_result_id number,
7120: c_table_alias varchar2 ) is

Line 7122: from BEN_WK_LOC_RT_F wlr

7118: --
7119: cursor c_wlr(c_wk_loc_rt_id number,c_mirror_src_entity_result_id number,
7120: c_table_alias varchar2 ) is
7121: select wlr.*
7122: from BEN_WK_LOC_RT_F wlr
7123: where wlr.wk_loc_rt_id = c_wk_loc_rt_id
7124: -- and wlr.business_group_id = p_business_group_id
7125: and not exists (
7126: select /* */ null

Line 7133: -- and trt.where_clause = 'BEN_WK_LOC_RT_F'

7129: where copy_entity_txn_id = p_copy_entity_txn_id
7130: -- and trt.table_route_id = cpe.table_route_id
7131: and ( -- c_mirror_src_entity_result_id is null or
7132: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7133: -- and trt.where_clause = 'BEN_WK_LOC_RT_F'
7134: and cpe.table_alias = c_table_alias
7135: and information1 = c_wk_loc_rt_id
7136: -- and information4 = wlr.business_group_id
7137: and information2 = wlr.effective_start_date

Line 7157: -- END OF BEN_WK_LOC_RT_F ----------------------

7153: where location_id = c_location_id;
7154:
7155: l_location_inactive_date hr_locations.inactive_date%type;
7156: ---------------------------------------------------------------
7157: -- END OF BEN_WK_LOC_RT_F ----------------------
7158: ---------------------------------------------------------------
7159: ---------------------------------------------------------------
7160: -- START OF BEN_COMPTNCY_RT_F ----------------------
7161: ---------------------------------------------------------------

Line 12467: -- START OF BEN_WK_LOC_RT_F ----------------------

12463: ---------------------------------------------------------------
12464: -- END OF BEN_VRBL_RT_PRFL_RL_F ----------------------
12465: ---------------------------------------------------------------
12466: ---------------------------------------------------------------
12467: -- START OF BEN_WK_LOC_RT_F ----------------------
12468: ---------------------------------------------------------------
12469: --
12470: for l_parent_rec in c_wlr_from_parent(l_VRBL_RT_PRFL_ID) loop
12471: --

Line 12610: -- END OF BEN_WK_LOC_RT_F ----------------------

12606: end loop;
12607: --
12608: end loop;
12609: ---------------------------------------------------------------
12610: -- END OF BEN_WK_LOC_RT_F ----------------------
12611: ---------------------------------------------------------------
12612: ---------------------------------------------------------------
12613: -- START OF BEN_COMPTNCY_RT_F ----------------------
12614: ---------------------------------------------------------------