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 1534: bom_shift_dates bsd,

1530: 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
1531: SELECT
1532: bst.from_time,bst.to_time
1533: FROM bom_resource_shifts brs,
1534: bom_shift_dates bsd,
1535: bom_shift_times bst
1536: WHERE brs.department_id = p_dept_id
1537: AND brs.resource_id = p_resource_id
1538: AND brs.shift_num = bsd.shift_num

Line 1700: bom_shift_dates bsd,

1696: 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
1697: SELECT
1698: bst.from_time,bst.to_time
1699: FROM bom_resource_shifts brs,
1700: bom_shift_dates bsd,
1701: bom_shift_times bst
1702: WHERE brs.department_id = p_dept_id
1703: AND brs.resource_id = p_resource_id
1704: AND brs.shift_num = bsd.shift_num

Line 1930: bom_shift_dates bsd,

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