19: lv_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
20:
21: CURSOR cur_get_setOfBooksId
22: (cpn_operating_unit_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE,
23: cpv_information_context HR_ORGANIZATION_INFORMATION.ORG_INFORMATION_CONTEXT%TYPE
24: )
25: IS
26: SELECT to_number(o3.org_information3) set_of_books_id
27: FROM hr_organization_information o3
23: cpv_information_context HR_ORGANIZATION_INFORMATION.ORG_INFORMATION_CONTEXT%TYPE
24: )
25: IS
26: SELECT to_number(o3.org_information3) set_of_books_id
27: FROM hr_organization_information o3
28: WHERE organization_id = cpn_operating_unit_id
29: AND o3.org_information_context = cpv_information_context;
30:
31: CURSOR cur_get_accrual_amount