427: SELECT gs.currency_code
428: FROM gl_sets_of_books gs
429: , ozf_sys_parameters org
430: WHERE org.set_of_books_id = gs.set_of_books_id
431: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
432:
433: CURSOR csr_claim_currency(cv_claim_id IN NUMBER) IS
434: SELECT currency_code
435: FROM ozf_claims
1336: SELECT gs.currency_code
1337: FROM gl_sets_of_books gs
1338: , ozf_sys_parameters org
1339: WHERE org.set_of_books_id = gs.set_of_books_id
1340: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
1341:
1342:
1343: l_api_version CONSTANT NUMBER := 1.0;
1344: l_api_name CONSTANT VARCHAR2(30) := 'Create_Claim_Line';
3084: SELECT gs.currency_code
3085: FROM gl_sets_of_books gs
3086: , ozf_sys_parameters org
3087: WHERE org.set_of_books_id = gs.set_of_books_id
3088: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
3089:
3090: -- Cursor to get earnings associated with this line
3091: CURSOR csr_get_lines_util(cv_claim_line_id IN NUMBER) IS
3092: SELECT claim_line_util_id