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