365: --Bugfix 4507953: Rely on translated balances select, rather than REQUEST_ID select
366: CURSOR c_translated_balances(p_request_id NUMBER, p_object_id NUMBER, p_ledger_id NUMBER, p_cal_period_id NUMBER) IS
367:
368: SELECT DISTINCT translated_currency
369: FROM fem_dl_trans_curr
370: WHERE request_id >= p_request_id
371: AND object_id = p_object_id
372: AND ledger_id = p_ledger_id
373: AND cal_period_id = p_cal_period_id;
3072:
3073: --Handle Translated balances
3074: SELECT DISTINCT translated_currency BULK COLLECT
3075: INTO l_xlated_curr_list
3076: FROM fem_dl_trans_curr
3077: WHERE request_id >= l_base_request_id
3078: AND object_id = l_bal_rule_id
3079: AND ledger_id = l_ledger_id
3080: AND cal_period_id = l_cal_period_id;