DBA Data[Home] [Help]

APPS.XTR_STOCK_PKG dependencies on XTR_JOURNALS

Line 559: from xtr_journals jnl

555: and b.tax_settled_reference is not null;
556:
557: cursor CHK_JOURNAL is
558: select 2
559: from xtr_journals jnl
560: where jnl.deal_type = 'STOCK'
561: and jnl.transaction_number = p_div_id
562: and ((jnl.amount_type = 'DIVSET' and jnl.deal_subtype = 'BUY')
563: or (jnl.amount_type = 'DIVEXP'))

Line 566: from xtr_journals a,

562: and ((jnl.amount_type = 'DIVSET' and jnl.deal_subtype = 'BUY')
563: or (jnl.amount_type = 'DIVEXP'))
564: union
565: select 2
566: from xtr_journals a,
567: xtr_rollover_transactions b
568: where a.deal_type = 'EXP'
569: and a.transaction_number = b.tax_settled_reference
570: and b.deal_type = 'STOCK'