APPS.XTR_JOURNAL_PROCESS_P dependencies on XTR_JOURNAL_ENTRY_ACTIONS

Line 650: from XTR_JOURNAL_ENTRY_ACTIONS a,

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
653: XTR_JOURNAL_ENTRY_ACTIONS f, -- " " " " " "
654: XTR_BANK_ACCOUNTS g

Line 653: XTR_JOURNAL_ENTRY_ACTIONS f, -- " " " " " "

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
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

Line 752: -- NOTE: Q4 will process accruals from XTR_JOURNAL_ENTRY_ACTIONS

748:
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

Line 776: xtr_journal_entry_actions jea

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'
780: and jea.company_code = acc.company_code

Line 830: xtr_journal_entry_actions jea,

826: ,jea.amount_type amount_type
827: ,jea.action_code action_code
828: ,jea.date_type date_type
829: from xtr_gain_loss_dnm dnm,
830: xtr_journal_entry_actions jea,
831: xtr_deals dea
832: where dnm.batch_id = in_batch_id
833: and jea.company_code = in_company
834: and jea.date_type = dnm.date_type

Line 874: xtr_journal_entry_actions jea,

870: ,jea.amount_type amount_type
871: ,jea.action_code action_code
872: ,jea.date_type date_type
873: from xtr_gain_loss_dnm dnm,
874: xtr_journal_entry_actions jea,
875: xtr_rollover_transactions ro
876: where dnm.batch_id = in_batch_id
877: and jea.company_code = in_company
878: and jea.date_type = dnm.date_type

Line 916: xtr_journal_entry_actions jea,

912: ,jea.amount_type amount_type
913: ,jea.action_code action_code
914: ,jea.date_type date_type
915: from xtr_gain_loss_dnm dnm,
916: xtr_journal_entry_actions jea,
917: xtr_intergroup_transfers ig
918: where dnm.batch_id = in_batch_id
919: and jea.company_code = in_company
920: and jea.date_type = dnm.date_type

Line 958: xtr_journal_entry_actions jea,

954: ,jea.amount_type amount_type
955: ,jea.action_code action_code
956: ,jea.date_type date_type
957: from xtr_gain_loss_dnm dnm,
958: xtr_journal_entry_actions jea,
959: xtr_revaluation_details rd,
960: xtr_bank_accounts ba,
961: xtr_bank_balances bb
962: where dnm.batch_id = in_batch_id

Line 1024: XTR_JOURNAL_ENTRY_ACTIONS jea

1020: jea.date_type date_type,
1021: dnm.reval_eff_flag reval_eff_flag
1022: from XTR_GAIN_LOSS_DNM dnm,
1023: XTR_DEALS dea,
1024: XTR_JOURNAL_ENTRY_ACTIONS jea
1025: Where dnm.batch_id = in_batch_id
1026: And jea.company_code = in_company
1027: And jea.company_code = dnm.company_code
1028: And jea.amount_type = dnm.amount_type