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_SHIFT_DATES

Line 1537: bom_shift_dates bsd,

1533: CURSOR l_date_shifts_csr_type(p_dept_id IN NUMBER,p_resource_id IN NUMBER,p_calendar_code IN VARCHAR2,p_date IN DATE) IS
1534: SELECT
1535: bst.from_time,bst.to_time
1536: FROM bom_resource_shifts brs,
1537: bom_shift_dates bsd,
1538: bom_shift_times bst
1539: WHERE brs.department_id = p_dept_id
1540: AND brs.resource_id = p_resource_id
1541: AND brs.shift_num = bsd.shift_num

Line 1703: bom_shift_dates bsd,

1699: CURSOR l_date_shifts_csr_type(p_dept_id IN NUMBER,p_resource_id IN NUMBER,p_calendar_code IN VARCHAR2,p_date IN DATE) IS
1700: SELECT
1701: bst.from_time,bst.to_time
1702: FROM bom_resource_shifts brs,
1703: bom_shift_dates bsd,
1704: bom_shift_times bst
1705: WHERE brs.department_id = p_dept_id
1706: AND brs.resource_id = p_resource_id
1707: AND brs.shift_num = bsd.shift_num

Line 1933: bom_shift_dates bsd,

1929: NUMBER,p_calendar_code IN VARCHAR2,p_date IN DATE) IS
1930: SELECT
1931: bst.from_time,bst.to_time
1932: FROM bom_resource_shifts brs,
1933: bom_shift_dates bsd,
1934: bom_shift_times bst
1935: WHERE brs.department_id = p_dept_id
1936: AND brs.resource_id = p_resource_id
1937: AND brs.shift_num = bsd.shift_num