APPS.EAM_OTL_TIMECARD_PUB dependencies on BOM_WORKDAY_PATTERNS

Line 1637: from bom_workday_patterns

1633: l_stmt_num NUMBER;
1634:
1635: CURSOR seq_num_calendar IS
1636: select days_off,days_on, (days_off+days_on) as total_days
1637: from bom_workday_patterns
1638: where calendar_code = l_calendar_code
1639: and shift_num is null
1640: and seq_num is not null
1641: order by seq_num;

Line 1654: from bom_workday_patterns

1650:
1651:
1652: select SUM(days_off + days_on)
1653: into l_day_block
1654: from bom_workday_patterns
1655: where calendar_code = l_calendar_code
1656: and shift_num is null
1657: and seq_num is not null
1658: group by calendar_code;