APPS.MRP_LINE_SCHEDULE_ALGORITHM dependencies on BOM_RESOURCE_FLEX_FENCES

Line 160: from bom_resource_flex_fences

156: v_days_out := mrp_calendar.DAYS_BETWEEN(p_org_id,1,sysdate,to_date(p_date,'J'));
157:
158: select nvl(max(FENCE_DAYS),-1)
159: into v_fence_days
160: from bom_resource_flex_fences
161: where fence_days <= v_days_out
162: and department_id = p_line_id;
163:
164: if v_fence_days > -1 then

Line 167: from bom_resource_flex_fences

163:
164: if v_fence_days > -1 then
165: select max(tolerance_percentage)
166: into v_tol_percent
167: from bom_resource_flex_fences
168: where fence_days = v_fence_days
169: and department_id = p_line_id;
170: else
171: return 0;