DBA Data[Home] [Help]

APPS.XTR_JOURNAL_PROCESS_P dependencies on XTR_BANK_ACCOUNTS

Line 654: XTR_BANK_ACCOUNTS g

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
653: XTR_JOURNAL_ENTRY_ACTIONS f, -- " " " " " "
654: XTR_BANK_ACCOUNTS g
655: where e.company_code = in_company
656: and e.batch_id is null
657: and e.amount_date <= in_period_end -- Reverted Back to amount_date Bug 5235988
658: and e.deal_type NOT IN ('EXP')

Line 733: XTR_BANK_ACCOUNTS bnk

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
734: where dda.company_code = in_company
735: and dda.amount_date <= in_period_end
736: and dda.batch_id is null
737: and dda.settle = 'Y'

Line 961: xtr_bank_accounts ba,

957: ,jea.date_type date_type
958: from xtr_gain_loss_dnm dnm,
959: xtr_journal_entry_actions jea,
960: xtr_revaluation_details rd,
961: xtr_bank_accounts ba,
962: xtr_bank_balances bb
963: where dnm.batch_id = in_batch_id
964: and jea.company_code = in_company -- JEA
965: and jea.date_type = dnm.date_type -- DNM