APPS.JMF_SHIKYU_WIP_PVT dependencies on MTL_PARAMETERS

Line 136: , mtl_parameters mp

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)
140: AND seq_num IS NULL;

Line 169: mtl_parameters mp

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);
173: