APPS.EAM_OTL_TIMECARD_PUB dependencies on BOM_WORKDAY_PATTERNS

Line 1632: from bom_workday_patterns

1628: l_stmt_num NUMBER;
1629:
1630: CURSOR seq_num_calendar IS
1631: select days_off,days_on, (days_off+days_on) as total_days
1632: from bom_workday_patterns
1633: where calendar_code = l_calendar_code
1634: and shift_num is null
1635: and seq_num is not null
1636: order by seq_num;

Line 1649: from bom_workday_patterns

1645:
1646:
1647: select SUM(days_off + days_on)
1648: into l_day_block
1649: from bom_workday_patterns
1650: where calendar_code = l_calendar_code
1651: and shift_num is null
1652: and seq_num is not null
1653: group by calendar_code;