APPS.AHL_LTP_RESRC_LEVL_PVT dependencies on BOM_WORKDAY_PATTERNS

Line 3390: SELECT DAYS_ON, DAYS_OFF FROM bom_workday_patterns

3386: WHERE CALENDAR_CODE = p_calendar_code AND
3387: SHIFT_NUM = p_shift_num;
3388:
3389: CURSOR l_workday_pattern_csr(p_calendar_code IN VARCHAR2, p_shift_num IN NUMBER) IS
3390: SELECT DAYS_ON, DAYS_OFF FROM bom_workday_patterns
3391: WHERE CALENDAR_CODE = p_calendar_code AND
3392: SHIFT_NUM = p_shift_num;
3393:
3394: CURSOR l_calendar_csr(p_calendar_code IN VARCHAR2) IS

Line 4062: SELECT DAYS_ON, DAYS_OFF FROM bom_workday_patterns

4058: WHERE CALENDAR_CODE = p_calendar_code AND
4059: SHIFT_NUM = p_shift_num;
4060:
4061: CURSOR l_workday_pattern_csr(p_calendar_code IN VARCHAR2, p_shift_num IN NUMBER) IS
4062: SELECT DAYS_ON, DAYS_OFF FROM bom_workday_patterns
4063: WHERE CALENDAR_CODE = p_calendar_code AND
4064: SHIFT_NUM = p_shift_num;
4065:
4066: CURSOR l_calendar_csr(p_calendar_code IN VARCHAR2) IS