2014: p_org_id IN NUMBER)
2015: IS
2016: SELECT gs.set_of_books_id
2017: ,gs.currency_code
2018: FROM gl_sets_of_books gs
2019: ,org_organization_definitions org
2020: WHERE gs.mrc_sob_type_code = 'P'
2021: AND org.set_of_books_id = gs.set_of_books_id
2022: AND org.operating_unit = p_org_id;
2025: CURSOR c_get_gl_info( p_org_id IN NUMBER)
2026: IS
2027: SELECT gs.set_of_books_id
2028: , gs.currency_code
2029: FROM gl_sets_of_books gs
2030: , ozf_sys_parameters_all org
2031: WHERE org.set_of_books_id = gs.set_of_books_id
2032: AND NVL(org.org_id, -99) = NVL(p_org_id, -99);
2033:
2200: p_org_id IN NUMBER)
2201: IS
2202: SELECT gs.set_of_books_id
2203: ,gs.currency_code
2204: FROM gl_sets_of_books gs
2205: ,org_organization_definitions org
2206: WHERE org.set_of_books_id = gs.set_of_books_id
2207: AND org.operating_unit = p_org_id;
2208: */
2210: CURSOR c_get_gl_info(p_org_id IN NUMBER)
2211: IS
2212: SELECT gs.set_of_books_id
2213: , gs.currency_code
2214: FROM gl_sets_of_books gs
2215: , ozf_sys_parameters_all org
2216: WHERE org.set_of_books_id = gs.set_of_books_id
2217: AND NVL(org.org_id, -99) = NVL(p_org_id, -99);
2218: