APPS.XTR_STOCK_PKG dependencies on XTR_STOCK_ALLOC_DETAILS

Line 249: from XTR_STOCK_ALLOC_DETAILS

245:
246: -- Add for SELL Stock cancellation. Bug 3222956
247: cursor UPD_BUY_DEAL is
248: select deal_no, quantity, cross_ref_start_date, init_consideration
249: from XTR_STOCK_ALLOC_DETAILS
250: where cross_ref_no = p_deal_no;
251:
252: cursor UPD_BUY_DIV(p_buy_deal NUMBER, p_sell_date DATE) is
253: select transaction_number, quantity, interest_rate,

Line 415: Update XTR_STOCK_ALLOC_DETAILS

411:
412: End loop;
413: CLOSE UPD_BUY_DIV;
414:
415: Update XTR_STOCK_ALLOC_DETAILS
416: set remaining_quantity = remaining_quantity + l_quantity
417: where deal_no = l_buy_deal
418: and ((cross_ref_start_date > l_sell_start_date)
419: or (cross_ref_start_date = l_sell_start_date and cross_ref_no > p_deal_no));

Line 425: Delete from XTR_STOCK_ALLOC_DETAILS

421: Fetch UPD_BUY_DEAL into l_buy_deal, l_quantity, l_sell_start_date, l_init_cons;
422: End loop;
423: Close UPD_BUY_DEAL;
424:
425: Delete from XTR_STOCK_ALLOC_DETAILS
426: where cross_ref_no = p_deal_no;
427:
428: end if;
429:

Line 638: from xtr_stock_alloc_details b

634: and d.status_code <> 'CANCELLED'
635: and d.bond_issue = p_stock_issue
636: and d.start_date <= p_record_date
637: and d.quantity > (select nvl(sum(b.quantity),0)
638: from xtr_stock_alloc_details b
639: where b.deal_no = d.deal_no
640: and b.cross_ref_start_date <= p_record_date)
641: and not exists (select 1
642: from xtr_rollover_transactions r

Line 684: from xtr_stock_alloc_details b

680: and d.deal_no = nvl(p_deal_no,deal_no)
681: and d.bond_issue = p_stock_issue
682: and d.start_date <= p_record_date
683: and d.quantity > (select nvl(sum(b.quantity),0)
684: from xtr_stock_alloc_details b
685: where b.deal_no = d.deal_no
686: and b.cross_ref_start_date <= p_record_date)
687: and not exists (select 1
688: from xtr_rollover_transactions r

Line 731: from xtr_stock_alloc_details

727: -- Find total quantity sold if there are any sell
728: -------------------------------------------------
729: cursor QTY_SOLD (l_deal_no NUMBER) is
730: select nvl(sum(QUANTITY),0)
731: from xtr_stock_alloc_details
732: where deal_no = l_deal_no
733: and cross_ref_start_date <= p_record_date;
734:
735: -------------------------------------------------

Line 752: from xtr_stock_alloc_details s,

748: d.DEALER_CODE,
749: d.CLIENT_CODE,
750: d.CPARTY_CODE,
751: d.PRODUCT_TYPE
752: from xtr_stock_alloc_details s,
753: xtr_deals d
754: where s.deal_no = l_buy_deal_no
755: and s.cross_ref_start_date <= p_record_date
756: and s.cross_ref_no = d.deal_no