APPS.JAI_OM_WDD_PROCESSING_PKG dependencies on HR_OPERATING_UNITS

Line 560: v_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;

556: b.line_id = v_source_line_id AND
557: a.header_id = v_source_header_id ;
558:
559: v_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;
560: v_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;
561: v_conv_type_code oe_order_headers_all.conversion_type_code%TYPE;
562: v_conv_rate NUMBER;
563: v_conv_date DATE;
564:

Line 2062: Get the Currency code using the current org id from the table hr_operating_units and gl_sets_of_books

2058: FROM wsh_delivery_assignments
2059: WHERE delivery_detail_id = pr_trig_row.delivery_detail_id;
2060:
2061: /*
2062: Get the Currency code using the current org id from the table hr_operating_units and gl_sets_of_books
2063: */
2064:
2065: CURSOR Sob_Cur IS
2066: SELECT gsb.currency_code

Line 2067: FROM hr_operating_units hru, gl_sets_of_books gsb

2063: */
2064:
2065: CURSOR Sob_Cur IS
2066: SELECT gsb.currency_code
2067: FROM hr_operating_units hru, gl_sets_of_books gsb
2068: WHERE gsb.set_of_books_id = hru.set_of_books_id
2069: AND hru.organization_id = pr_trig_row.org_id;
2070:
2071: CURSOR c_curr_precision(cp_curr_code VARCHAR2) IS

Line 2946: v_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;

2942: b.line_id = v_source_line_id AND
2943: a.header_id = v_source_header_id ;
2944:
2945: v_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;
2946: v_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;
2947: v_conv_type_code oe_order_headers_all.conversion_type_code%TYPE;
2948: v_conv_rate NUMBER;
2949: v_conv_date DATE;
2950: v_curr_conv_rate NUMBER;