DBA Data[Home] [Help]

APPS.EAM_ASSIGN_EMP_PUB dependencies on BOM_SHIFT_TIMES

Line 1535: bom_shift_times bst

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

Line 1701: bom_shift_times bst

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

Line 1931: bom_shift_times bst

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