eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_COMMON_FUNCTIONS dependencies on XTR_JOURNALS

Line 516: FROM xtr_journals

512: p_check_intset_record IN VARCHAR2 DEFAULT 'N') RETURN BOOLEAN IS
513:
514: CURSOR chk_jrnls IS
515: SELECT ('Y')
516: FROM xtr_journals
517: WHERE deal_number =nvl(p_deal_number, deal_number)
518: AND transaction_number =nvl(p_transaction_number,transaction_number);
519:
520: CURSOR chk_jrnls_for_intset IS

Line 522: FROM xtr_journals

518: AND transaction_number =nvl(p_transaction_number,transaction_number);
519:
520: CURSOR chk_jrnls_for_intset IS
521: SELECT ('Y')
522: FROM xtr_journals
523: WHERE deal_number =nvl(p_deal_number, deal_number)
524: AND transaction_number =nvl(p_transaction_number,transaction_number)
525: AND amount_type = 'INTSET'
526: AND journal_date > p_date; -- for bug 5444438

Line 535: FROM xtr_journals

531:
532: IF p_deal_type in ('TMM','IRS') AND p_date is not null THEN
533: SELECT max(journal_date)
534: INTO l_intset_date
535: FROM xtr_journals
536: WHERE deal_number = p_deal_number
537: AND amount_type = 'INTSET';
538:
539: IF p_date < l_intset_date THEN