[Home] [Help]
749: Q3_REC Q3%ROWTYPE;
750:
751: ----------------------------------------------------------------------------------------------
752: -- NOTE: Q4 will process accruals from XTR_JOURNAL_ENTRY_ACTIONS
753: -- (where date type = 'ACCRUAL') and join it to XTR_ACCRLS_AMORT
754: -- to create journal entries.
755: ----------------------------------------------------------------------------------------------
756: Cursor Q4 is
757: Select
771: ,jea.code_combination_id ccid
772: ,acc.rowid row_id
773: ,jea.date_type date_type
774: ,jea.action_code action_code
775: from xtr_accrls_amort acc,
776: xtr_journal_entry_actions jea
777: where acc.batch_id = in_batch_id
778: and jea.company_code = in_company
779: and jea.date_type = 'ACCRUAL'