355:
356:
357: /*
358: The following cursor has been added by aiyer for the bug #3039521.
359: Get the Currency code using the current org id from the table hr_operating_units and gl_sets_of_books
360: */
361: -- Start of cursor added by aiyer for the bug #3039521
362: /* bug 5243532. Added by Lakshmi Gopalsami
363: Removed the reference to cursor sob_cur
363: Removed the reference to cursor sob_cur
364: as this is not used anywhere.
365: */
366:
367: v_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;
368:
369: -- End of cursor Sob_Cur added for the bug #3039521.
370: -- Start Of Bug #
371: CURSOR c_chk_exc_exmpt_rule
1213: a.header_id = b.header_id AND
1214: b.line_id = v_source_line_id AND
1215: a.header_id = v_source_header_id ;
1216:
1217: v_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;
1218: v_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;
1219: v_conv_type_code oe_order_headers_all.conversion_type_code%TYPE;
1220: v_conv_rate NUMBER;
1221: v_conv_date DATE;