1155: CURSOR c_accrl_deal IS
1156: SELECT max(period_to)
1157: FROM
1158: xtr_bank_balances bb, xtr_bank_accounts ba,
1159: xtr_deal_date_amounts dd, xtr_accrls_amort aa
1160: WHERE bb.company_code = p_company_code
1161: AND bb.account_number = p_account_number
1162: AND bb.company_code = ba.party_code
1163: AND bb.account_number = ba.account_number
1718: CURSOR c_accrl_deal IS
1719: SELECT max(period_to)
1720: FROM
1721: xtr_bank_balances bb, xtr_bank_accounts ba,
1722: xtr_deal_date_amounts dd, xtr_accrls_amort aa
1723: WHERE bb.company_code = p_company_code
1724: AND bb.account_number = p_account_number
1725: AND bb.company_code = ba.party_code
1726: AND bb.account_number = ba.account_number