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 753: -- NOTE: Q4 will process accruals from XTR_JOURNAL_ENTRY_ACTIONS

749:
750: Q3_REC Q3%ROWTYPE;
751:
752: ----------------------------------------------------------------------------------------------
753: -- NOTE: Q4 will process accruals from XTR_JOURNAL_ENTRY_ACTIONS
754: -- (where date type = 'ACCRUAL') and join it to XTR_ACCRLS_AMORT
755: -- to create journal entries.
756: ----------------------------------------------------------------------------------------------
757: Cursor Q4 is

Line 777: xtr_journal_entry_actions jea

773: ,acc.rowid row_id
774: ,jea.date_type date_type
775: ,jea.action_code action_code
776: from xtr_accrls_amort acc,
777: xtr_journal_entry_actions jea
778: where acc.batch_id = in_batch_id
779: and jea.company_code = in_company
780: and jea.date_type = 'ACCRUAL'
781: and jea.company_code = acc.company_code

Line 831: xtr_journal_entry_actions jea,

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

Line 875: xtr_journal_entry_actions jea,

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

Line 917: xtr_journal_entry_actions jea,

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

Line 959: xtr_journal_entry_actions jea,

955: ,jea.amount_type amount_type
956: ,jea.action_code action_code
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

Line 1025: XTR_JOURNAL_ENTRY_ACTIONS jea

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