1295: CURSOR c_reval_deal IS
1296: SELECT max(period_to)
1297: FROM
1298: xtr_bank_balances bb,xtr_bank_accounts ba,
1299: xtr_revaluation_details rd
1300: WHERE
1301: bb.company_code = p_company_code
1302: AND bb.account_number = p_account_number
1303: AND bb.company_code = ba.party_code
1657: CURSOR c_reval_deal IS
1658: SELECT max(period_to)
1659: FROM
1660: xtr_bank_balances bb,xtr_bank_accounts ba,
1661: xtr_revaluation_details rd
1662: WHERE
1663: bb.company_code = p_company_code
1664: AND bb.account_number = p_account_number
1665: AND bb.company_code = ba.party_code