9: p_reverse_dda IN BOOLEAN) as
10:
11: cursor CUR_DEAL is
12: select * 13: from XTR_DEALS_V 14: where deal_no = p_deal_no;
15:
16: D CUR_DEAL%ROWTYPE;
17:
Line 240: from XTR_DEALS_V
236: for update of status_code nowait;
237:
238: cursor BKGE_EXP is
239: select BKGE_SETTLED_REFERENCE 240: from XTR_DEALS_V 241: where deal_type = 'STOCK'
242: and deal_no = p_deal_no
243: and bkge_settled_reference is NOT NULL;
244: