[Home] [Help]
322: head.org_id = P_ORG_ID;
323:
324: CURSOR func_curr_cur(P_ORG_ID number) IS
325: select books.currency_code
326: from lns_system_options_all sys,
327: gl_sets_of_books books
328: where sys.org_id = P_ORG_ID and
329: sys.set_of_books_id = books.set_of_books_id;
330:
553: select org.ORGANIZATION_ID,
554: org.name,
555: null,
556: null
557: from lns_system_options_all sys,
558: hr_operating_units org
559: where sys.ORG_ID = org.ORGANIZATION_ID;
560:
561: BEGIN