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_JOURNAL_PROCESS_P dependencies on DUAL

Line 244: from DUAL;

240: -- Added for flex journals. 2404342. Creation of a new journal only batch.
241:
242: Cursor GEN_BATCH is
243: Select XTR_BATCHES_S.NEXTVAL
244: from DUAL;
245:
246: l_retcode NUMBER := 0;
247: l_warn_flag BOOLEAN;
248: l_sub_retcode NUMBER := 0; -- Added for 1336492.

Line 607: from dual

603: l_empty number := 0;
604:
605: Cursor Entries (bid number) is
606: Select 1
607: from dual
608: where exists (select null
609: from xtr_journals
610: where batch_id = bid);
611: -- Bug 3805480 end

Line 615: From DUAL;

611: -- Bug 3805480 end
612:
613: Cursor EVENT_ID is
614: Select XTR_BATCH_EVENTS_S.NEXTVAL
615: From DUAL;
616:
617: --------------------------------------------------------------------------------
618: -- NOTE: Q2 will select all deal types except 'EXP' for journal generation.
619: -- Tables e (DDA) and f (JEA) are the driving tables, with table a (JEA)

Line 648: ,decode(a.deal_type,'CA','-1',c.dual_authorisation_by) validated_by -- Added for 1336492.

644: ,a.get_int_ccid_from_deal use_int_ccid_flag
645: ,c.cparty_account_no cparty_account_no
646: ,e.cparty_code cparty_code
647: ,a.action_code action_code
648: ,decode(a.deal_type,'CA','-1',c.dual_authorisation_by) validated_by -- Added for 1336492.
649: ,c.account_no co_account_no -- Added for 1336492.
650: from XTR_JOURNAL_ENTRY_ACTIONS a,
651: XTR_DEAL_DATE_AMOUNTS c,
652: XTR_DEAL_DATE_AMOUNTS e, -- To generate Journal for Bank Acct

Line 729: ,dda.dual_authorisation_by validated_by -- Added for 1336492.

725: ,bnk.code_combination_id bank_ccid
726: ,dda.settlement_number settlement_number
727: ,dda.date_type date_type
728: ,dda.action_code action_code
729: ,dda.dual_authorisation_by validated_by -- Added for 1336492.
730: from XTR_DEAL_DATE_AMOUNTS_V dda,
731: XTR_EXPOSURE_TRANSACTIONS exp,
732: XTR_EXPOSURE_TYPES typ,
733: XTR_BANK_ACCOUNTS bnk

Line 1151: Select dual_authorisation_by

1147: l_val_flag in varchar2,
1148: l_co_account_no in varchar2) RETURN BOOLEAN IS
1149:
1150: Cursor DEAL_VAL_BY is
1151: Select dual_authorisation_by
1152: from xtr_deals
1153: where deal_no = l_deal_no;
1154:
1155: Cursor GET_USER_DEAL_TYPE is

Line 1163: l_deal_val_by XTR_DEALS.dual_authorisation_by%TYPE := NULL;

1159:
1160:
1161:
1162:
1163: l_deal_val_by XTR_DEALS.dual_authorisation_by%TYPE := NULL;
1164: l_ret_value boolean;
1165: l_user_deal_type XTR_DEAL_TYPES.user_deal_type%TYPE := NULL;
1166: l_trans_no_1 number := l_trans_no;
1167:

Line 1296: Open VALREQ('DUAL_AUTHORISE_IAC');

1292: l_valreq := nvl(l_valreq,'N');
1293:
1294:
1295: -- Bug 3800146 IAC redesign
1296: Open VALREQ('DUAL_AUTHORISE_IAC');
1297: Fetch VALREQ into l_iac_valreq;
1298: Close VALREQ;
1299: l_iac_valreq := nvl(l_iac_valreq,'N');
1300: