[Home] [Help]
692: Q2_REC Q2%ROWTYPE;
693:
694: ----------------------------------------------------------------------------------------------
695: -- NOTE: Q3 are for Exposure transactions. EXP actions are not entered into JEA.
696: -- They are entered into XTR_EXPOSURE_TYPES table by company/exposure type.
697: -- However, DDA does get updated for Exposure transactions. Two journal entries
698: -- should be created for EXP deals, one for the exposure side and the other
699: -- for the bank account side. Journals should be generated only after the
700: -- transaction has been settled, when no further changes to the transaction
727: ,dda.action_code action_code
728: ,dda.dual_authorisation_by validated_by -- Added for 1336492.
729: from XTR_DEAL_DATE_AMOUNTS_V dda,
730: XTR_EXPOSURE_TRANSACTIONS exp,
731: XTR_EXPOSURE_TYPES typ,
732: XTR_BANK_ACCOUNTS bnk
733: where dda.company_code = in_company
734: and dda.amount_date <= in_period_end
735: and dda.batch_id is null