APPS.OE_VALIDATE_LINE dependencies on OE_BLANKET_LINES_ALL

Line 3007: l_ordered_item OE_BLANKET_LINES_ALL.ORDERED_ITEM%TYPE; --Bug 7635963

3003: l_postal_code VARCHAR2(240);
3004: l_country VARCHAR2(240);
3005:
3006: l_ordered_item_id NUMBER;
3007: l_ordered_item OE_BLANKET_LINES_ALL.ORDERED_ITEM%TYPE; --Bug 7635963
3008: BEGIN
3009:
3010: x_return_status := fnd_api.g_ret_sts_success;
3011:

Line 3130: FROM OE_BLANKET_LINES_ALL BL,OE_BLANKET_HEADERS BH,

3126: l_enforce_payment_term_flag,
3127: l_enforce_accounting_rule_flag,
3128: l_enforce_invoicing_rule_flag,
3129: l_flow_status_code
3130: FROM OE_BLANKET_LINES_ALL BL,OE_BLANKET_HEADERS BH,
3131: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
3132: WHERE BLE.ORDER_NUMBER = p_line_rec.blanket_number
3133: AND BLE.LINE_NUMBER = p_line_rec.blanket_line_number
3134: AND BHE.ORDER_NUMBER = BLE.ORDER_NUMBER