APPS.XTR_JOURNAL_PROCESS_P dependencies on XTR_DEAL_DATE_AMOUNTS

Line 651: XTR_DEAL_DATE_AMOUNTS c,

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
655: where e.company_code = in_company

Line 652: XTR_DEAL_DATE_AMOUNTS e, -- To generate Journal for Bank Acct

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
655: where e.company_code = in_company
656: and e.batch_id is null

Line 729: from XTR_DEAL_DATE_AMOUNTS_V dda,

725: ,dda.settlement_number settlement_number
726: ,dda.date_type date_type
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

Line 1628: Update XTR_DEAL_DATE_AMOUNTS

1624: END IF;
1625:
1626: -- Update DDA to put BATCH_ID value once journal is generated
1627:
1628: Update XTR_DEAL_DATE_AMOUNTS
1629: set BATCH_ID = l_batch_id
1630: where deal_type = l_prev_deal_type
1631: and deal_number = l_prev_deal_nbr
1632: and transaction_number = l_prev_transaction_nbr

Line 1697: Update XTR_DEAL_DATE_AMOUNTS

1693: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1694: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Update last batch of Q2 data.');
1695: END IF;
1696:
1697: Update XTR_DEAL_DATE_AMOUNTS
1698: set batch_id = l_batch_id
1699: where deal_type = l_prev_deal_type
1700: and date_type = l_prev_date_type
1701: and deal_number = l_prev_deal_nbr

Line 2007: Update XTR_DEAL_DATE_AMOUNTS

2003:
2004: -- 1336492. Added update condition.
2005:
2006: If (nvl(l_updt_flag,'Y') = 'Y') then
2007: Update XTR_DEAL_DATE_AMOUNTS
2008: set BATCH_ID = l_batch_id
2009: where company_code = in_company
2010: and deal_type = 'EXP'
2011: and deal_number = Q3_REC.deal_number