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.EAM_ASSIGN_EMP_PUB dependencies on BOM_CALENDAR_DATES

Line 268: FROM bom_calendar_dates

264:
265: --calculate the hours in case the resource is 24 hours exclusing exception dates
266: CURSOR l_res_24_hours_csr_type(l_horizon_start_date IN DATE,l_horizon_end_date IN DATE) IS
267: SELECT nvl(SUM(1*24),0) AS hours_24
268: FROM bom_calendar_dates
269: WHERE calendar_code = p_calendar_code
270: AND calendar_date BETWEEN l_horizon_start_date AND l_horizon_end_date
271: AND seq_num IS NOT NULL ;
272:

Line 1504: FROM bom_calendar_dates bcd

1500: RETURN CHAR
1501: AS
1502: CURSOR l_date_check_csr_type(p_calendar_code IN VARCHAR2,p_date IN DATE) IS
1503: SELECT 1
1504: FROM bom_calendar_dates bcd
1505: WHERE bcd.calendar_code = p_calendar_code
1506: AND calendar_date = p_date
1507: AND seq_num IS NOT NULL ;
1508: