DBA Data[Home] [Help]

APPS.EAM_ASSIGN_EMP_PUB dependencies on BOM_SHIFT_TIMES

Line 1538: bom_shift_times bst

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
1542: AND bsd.seq_num is not null

Line 1704: bom_shift_times bst

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
1708: AND bsd.seq_num is not null

Line 1934: bom_shift_times bst

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
1938: AND bsd.seq_num is not null