APPS.OE_VALIDATE_LINE dependencies on OE_BLANKET_LINES_ALL

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

3128: l_postal_code VARCHAR2(240);
3129: l_country VARCHAR2(240);
3130:
3131: l_ordered_item_id NUMBER;
3132: l_ordered_item OE_BLANKET_LINES_ALL.ORDERED_ITEM%TYPE; --Bug 7635963
3133: BEGIN
3134:
3135: x_return_status := fnd_api.g_ret_sts_success;
3136:

Line 3255: FROM OE_BLANKET_LINES_ALL BL,OE_BLANKET_HEADERS BH,

3251: l_enforce_payment_term_flag,
3252: l_enforce_accounting_rule_flag,
3253: l_enforce_invoicing_rule_flag,
3254: l_flow_status_code
3255: FROM OE_BLANKET_LINES_ALL BL,OE_BLANKET_HEADERS BH,
3256: OE_BLANKET_HEADERS_EXT BHE,OE_BLANKET_LINES_EXT BLE
3257: WHERE BLE.ORDER_NUMBER = p_line_rec.blanket_number
3258: AND BLE.LINE_NUMBER = p_line_rec.blanket_line_number
3259: AND BHE.ORDER_NUMBER = BLE.ORDER_NUMBER