APPS.JMF_SHIKYU_WIP_PVT dependencies on BOM_CALENDAR_DATES

Line 135: FROM bom_calendar_dates bcd

131: -- since on/off days should be considered.
132:
133: SELECT count(1)
134: INTO l_off_days
135: FROM bom_calendar_dates bcd
136: , mtl_parameters mp
137: WHERE bcd.calendar_code = mp.calendar_code
138: AND mp.organization_id = p_tp_organization
139: AND bcd.calendar_date BETWEEN TRUNC(l_start_date) AND TRUNC(p_need_by_date)

Line 168: FROM bom_calendar_dates bcd,

164: SELECT bcd.seq_num,
165: bcd.prior_date
166: INTO l_seq_num,
167: l_prior_date
168: FROM bom_calendar_dates bcd,
169: mtl_parameters mp
170: WHERE bcd.calendar_code = mp.calendar_code
171: AND mp.organization_id = p_tp_organization
172: AND TRUNC(bcd.calendar_date) = TRUNC(l_start_date);

Line 179: , '>> '||l_program||': From bom_calendar_dates: l_seq_num = '|| NVL(TO_CHAR(l_seq_num), 'NULL')

175: (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
176: THEN
177: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
178: , G_PKG_NAME
179: , '>> '||l_program||': From bom_calendar_dates: l_seq_num = '|| NVL(TO_CHAR(l_seq_num), 'NULL')
180: || ', l_prior_date = ' || l_prior_date
181: );
182: END IF;
183: