DBA Data[Home] [Help]

APPS.XTR_JOURNAL_PROCESS_P dependencies on XTR_EXPOSURE_TYPES

Line 697: -- They are entered into XTR_EXPOSURE_TYPES table by company/exposure type.

693: Q2_REC Q2%ROWTYPE;
694:
695: ----------------------------------------------------------------------------------------------
696: -- NOTE: Q3 are for Exposure transactions. EXP actions are not entered into JEA.
697: -- They are entered into XTR_EXPOSURE_TYPES table by company/exposure type.
698: -- However, DDA does get updated for Exposure transactions. Two journal entries
699: -- should be created for EXP deals, one for the exposure side and the other
700: -- for the bank account side. Journals should be generated only after the
701: -- transaction has been settled, when no further changes to the transaction

Line 732: XTR_EXPOSURE_TYPES typ,

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