eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_HRS_WKD_IN_PERD_RT_F

Line 6242: -- START OF BEN_HRS_WKD_IN_PERD_RT_F ----------------------

6238: ---------------------------------------------------------------
6239: -- END OF BEN_HRLY_SLRD_RT_F ----------------------
6240: ---------------------------------------------------------------
6241: ---------------------------------------------------------------
6242: -- START OF BEN_HRS_WKD_IN_PERD_RT_F ----------------------
6243: ---------------------------------------------------------------
6244: cursor c_hwr_from_parent(c_VRBL_RT_PRFL_ID number) is
6245: select distinct hrs_wkd_in_perd_rt_id
6246: from BEN_HRS_WKD_IN_PERD_RT_F

Line 6246: from BEN_HRS_WKD_IN_PERD_RT_F

6242: -- START OF BEN_HRS_WKD_IN_PERD_RT_F ----------------------
6243: ---------------------------------------------------------------
6244: cursor c_hwr_from_parent(c_VRBL_RT_PRFL_ID number) is
6245: select distinct hrs_wkd_in_perd_rt_id
6246: from BEN_HRS_WKD_IN_PERD_RT_F
6247: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6248: --
6249: cursor c_hwr(c_hrs_wkd_in_perd_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
6250: select hwr.*

Line 6251: from BEN_HRS_WKD_IN_PERD_RT_F hwr

6247: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6248: --
6249: cursor c_hwr(c_hrs_wkd_in_perd_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
6250: select hwr.*
6251: from BEN_HRS_WKD_IN_PERD_RT_F hwr
6252: where hwr.hrs_wkd_in_perd_rt_id = c_hrs_wkd_in_perd_rt_id
6253: -- and hwr.business_group_id = p_business_group_id
6254: and not exists (
6255: select /* */ null

Line 6262: -- and trt.where_clause = 'BEN_HRS_WKD_IN_PERD_RT_F'

6258: where copy_entity_txn_id = p_copy_entity_txn_id
6259: -- and trt.table_route_id = cpe.table_route_id
6260: and ( -- c_mirror_src_entity_result_id is null or
6261: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6262: -- and trt.where_clause = 'BEN_HRS_WKD_IN_PERD_RT_F'
6263: and cpe.table_alias = c_table_alias
6264: and information1 = c_hrs_wkd_in_perd_rt_id
6265: -- and information4 = hwr.business_group_id
6266: and information2 = hwr.effective_start_date

Line 6278: -- and trt.where_clause = 'BEN_HRS_WKD_IN_PERD_RT_F'

6274: -- pqh_table_route trt
6275: where copy_entity_txn_id = p_copy_entity_txn_id
6276: -- and trt.table_route_id = cpe.table_route_id
6277: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
6278: -- and trt.where_clause = 'BEN_HRS_WKD_IN_PERD_RT_F'
6279: and cpe.table_alias = c_table_alias
6280: and information1 = c_hrs_wkd_in_perd_rt_id
6281: -- and information4 = p_business_group_id
6282: ;

Line 6284: -- END OF BEN_HRS_WKD_IN_PERD_RT_F ----------------------

6280: and information1 = c_hrs_wkd_in_perd_rt_id
6281: -- and information4 = p_business_group_id
6282: ;
6283: ---------------------------------------------------------------
6284: -- END OF BEN_HRS_WKD_IN_PERD_RT_F ----------------------
6285: ---------------------------------------------------------------
6286: ---------------------------------------------------------------
6287: -- START OF BEN_LBR_MMBR_RT_F ----------------------
6288: ---------------------------------------------------------------

Line 9735: -- START OF BEN_HRS_WKD_IN_PERD_RT_F ----------------------

9731: ---------------------------------------------------------------
9732: -- END OF BEN_HRLY_SLRD_RT_F ----------------------
9733: ---------------------------------------------------------------
9734: ---------------------------------------------------------------
9735: -- START OF BEN_HRS_WKD_IN_PERD_RT_F ----------------------
9736: ---------------------------------------------------------------
9737: --
9738: hr_utility.set_location('START OF BEN_HRS_WKD_IN_PERD_RT_F ',100);
9739: for l_parent_rec in c_hwr_from_parent(l_VRBL_RT_PRFL_ID) loop

Line 9738: hr_utility.set_location('START OF BEN_HRS_WKD_IN_PERD_RT_F ',100);

9734: ---------------------------------------------------------------
9735: -- START OF BEN_HRS_WKD_IN_PERD_RT_F ----------------------
9736: ---------------------------------------------------------------
9737: --
9738: hr_utility.set_location('START OF BEN_HRS_WKD_IN_PERD_RT_F ',100);
9739: for l_parent_rec in c_hwr_from_parent(l_VRBL_RT_PRFL_ID) loop
9740: --
9741: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
9742:

Line 9855: hr_utility.set_location('END OF BEN_HRS_WKD_IN_PERD_RT_F ',100);

9851: ,p_effective_date => p_effective_date
9852: );
9853: end loop;
9854: end loop;
9855: hr_utility.set_location('END OF BEN_HRS_WKD_IN_PERD_RT_F ',100);
9856: ---------------------------------------------------------------
9857: -- END OF BEN_HRS_WKD_IN_PERD_RT_F ----------------------
9858: ---------------------------------------------------------------
9859: ---------------------------------------------------------------

Line 9857: -- END OF BEN_HRS_WKD_IN_PERD_RT_F ----------------------

9853: end loop;
9854: end loop;
9855: hr_utility.set_location('END OF BEN_HRS_WKD_IN_PERD_RT_F ',100);
9856: ---------------------------------------------------------------
9857: -- END OF BEN_HRS_WKD_IN_PERD_RT_F ----------------------
9858: ---------------------------------------------------------------
9859: ---------------------------------------------------------------
9860: -- START OF BEN_LBR_MMBR_RT_F ----------------------
9861: ---------------------------------------------------------------