APPS.XTR_REPLICATE_BANK_BALANCES dependencies on XTR_DEAL_DATE_AMOUNTS

Line 689: FROM xtr_deal_date_amounts

685:
686: -- Checking whether the row exists in the DDA table
687: CURSOR C_BAL_SETTLED IS
688: SELECT 'Y'
689: FROM xtr_deal_date_amounts
690: WHERE DEAL_TYPE = 'CA'
691: AND AMOUNT_TYPE = 'INTSET'
692: AND ACCOUNT_NO = p_balance_rec.account_number
693: AND CURRENCY = l_ccy

Line 706: -- Checking the lock on the xtr_deal_date_amounts table

702: AND account_number = p_balance_rec.account_number
703: AND ce_bank_account_balance_id = p_balance_rec.ce_bank_account_balance_id
704: FOR UPDATE NOWAIT;
705:
706: -- Checking the lock on the xtr_deal_date_amounts table
707: CURSOR c_chk_dda_lock IS
708: SELECT ce_bank_account_balance_id
709: FROM xtr_bank_balances
710: WHERE company_code = p_balance_rec.company_code

Line 756: DELETE FROM XTR_DEAL_DATE_AMOUNTS_V

752: CLOSE c_chk_dda_lock;
753:
754: IF c_bal_settled%FOUND THEN
755:
756: DELETE FROM XTR_DEAL_DATE_AMOUNTS_V
757: WHERE DEAL_TYPE = 'CA'
758: AND AMOUNT_TYPE = 'INTSET'
759: AND ACCOUNT_NO = p_balance_rec.account_number
760: AND CURRENCY = l_ccy

Line 1161: xtr_deal_date_amounts dd, xtr_accrls_amort aa

1157: CURSOR c_accrl_deal IS
1158: SELECT max(period_to)
1159: FROM
1160: xtr_bank_balances bb, xtr_bank_accounts ba,
1161: xtr_deal_date_amounts dd, xtr_accrls_amort aa
1162: WHERE bb.company_code = p_company_code
1163: AND bb.account_number = p_account_number
1164: AND bb.company_code = ba.party_code
1165: AND bb.account_number = ba.account_number

Line 1418: FROM XTR_DEAL_DATE_AMOUNTS_V

1414:
1415: -- To check whether the 'BAL' row exists in DDA table
1416: CURSOR C_BAL_EXISTS IS
1417: SELECT 'Y'
1418: FROM XTR_DEAL_DATE_AMOUNTS_V
1419: WHERE ACCOUNT_NO = p_account_number
1420: AND COMPANY_CODE = nvl(l_cross_ref,p_company_code)
1421: AND CURRENCY = l_ccy
1422: AND AMOUNT_DATE = p_balance_date

Line 1607: from XTR_DEAL_DATE_AMOUNTS_V

1603: WHERE ce_bank_account_id = p_ce_bank_account_id;
1604:
1605: cursor INT_SETTLED is
1606: select 'Y'
1607: from XTR_DEAL_DATE_AMOUNTS_V
1608: where DEAL_TYPE = 'CA'
1609: and AMOUNT_TYPE = 'INTSET'
1610: and ACCOUNT_NO = l_account_number
1611: and CURRENCY = l_currency

Line 1724: xtr_deal_date_amounts dd, xtr_accrls_amort aa

1720: CURSOR c_accrl_deal IS
1721: SELECT max(period_to)
1722: FROM
1723: xtr_bank_balances bb, xtr_bank_accounts ba,
1724: xtr_deal_date_amounts dd, xtr_accrls_amort aa
1725: WHERE bb.company_code = p_company_code
1726: AND bb.account_number = p_account_number
1727: AND bb.company_code = ba.party_code
1728: AND bb.account_number = ba.account_number