8: p_request_id IN NUMBER) IS
9:
10:
11: /* R12 : Ledger Architecture Changes : The table gl_mc_reporting_options will be obsolete, replace with
12: new table gl_alc_ledger_rships_v and corresponding columns */
13:
14: /* CURSOR c_reporting_sob ( p_set_of_books_id IN NUMBER, in_org_id IN NUMBER) IS
15: SELECT reporting_set_of_books_id,
16: reporting_currency_code,
25: CURSOR c_reporting_sob ( p_set_of_books_id IN NUMBER, in_org_id IN NUMBER) IS
26: SELECT ledger_id reporting_set_of_books_id,
27: currency_code reporting_currency_code,
28: alc_default_conv_rate_type conversion_type
29: FROM gl_alc_ledger_rships_v
30: WHERE source_ledger_id = p_set_of_books_id
31: AND application_id = 275
32: AND (org_id = -99 OR org_id = in_org_id)
33: AND relationship_enabled_flag = 'Y';