DBA Data[Home] [Help]

APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on HR_OPERATING_UNITS

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

380:
381:
382: /*
383: The following cursor has been added by aiyer for the bug #3039521.
384: Get the Currency code using the current org id from the table hr_operating_units and gl_sets_of_books
385: */
386: -- Start of cursor added by aiyer for the bug #3039521
387: /* bug 5243532. Added by Lakshmi Gopalsami
388: Removed the reference to cursor sob_cur

Line 1450: v_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;

1446: b.line_id = v_source_line_id AND
1447: a.header_id = v_source_header_id ;
1448:
1449: v_currency_code GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE ;
1450: v_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;
1451: v_conv_type_code oe_order_headers_all.conversion_type_code%TYPE;
1452: v_conv_rate NUMBER;
1453: v_conv_date DATE;
1454:

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

3687: FROM wsh_delivery_assignments
3688: WHERE delivery_detail_id = pr_trig_row.delivery_detail_id;
3689:
3690: /*
3691: Get the Currency code using the current org id from the table hr_operating_units and gl_sets_of_books
3692: */
3693:
3694: CURSOR Sob_Cur
3695: IS

Line 3697: FROM hr_operating_units hru ,

3693:
3694: CURSOR Sob_Cur
3695: IS
3696: SELECT gsb.currency_code
3697: FROM hr_operating_units hru ,
3698: gl_sets_of_books gsb
3699: WHERE gsb.set_of_books_id = hru.set_of_books_id AND
3700: hru.organization_id = pr_trig_row.org_id ;
3701: