APPS.JAI_CMN_UTILS_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 156: and org_organization_definitions. Replaced the same with caching logic.

152: IS
153: /* Bug 5243532. Added by Lakshmi Gopalsami
154: Removed the cursor c_set_of_books and c_operating_unit
155: which is referring to hr_operating_units
156: and org_organization_definitions. Replaced the same with caching logic.
157: Replaced gl_sets_of_books with gl_ledgers
158: */
159: CURSOR c_sob_currency (cp_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE) IS
160: SELECT currency_code

Line 246: p_inventory_orgn_id ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_ID%TYPE

242: END return_valid_date;
243:
244: FUNCTION get_operating_unit (
245: p_calling_object VARCHAR2 ,
246: p_inventory_orgn_id ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_ID%TYPE
247: ) RETURN NUMBER
248: IS
249: CURSOR c_operating_unit IS
250: SELECT operating_unit

Line 251: FROM org_organization_definitions

247: ) RETURN NUMBER
248: IS
249: CURSOR c_operating_unit IS
250: SELECT operating_unit
251: FROM org_organization_definitions
252: WHERE organization_id = p_inventory_orgn_id;
253:
254: ln_operating_unit_id ORG_ORGANIZATION_DEFINITIONS.OPERATING_UNIT%TYPE;
255:

Line 254: ln_operating_unit_id ORG_ORGANIZATION_DEFINITIONS.OPERATING_UNIT%TYPE;

250: SELECT operating_unit
251: FROM org_organization_definitions
252: WHERE organization_id = p_inventory_orgn_id;
253:
254: ln_operating_unit_id ORG_ORGANIZATION_DEFINITIONS.OPERATING_UNIT%TYPE;
255:
256: BEGIN
257: /*
258: || If the mandatory parameter p_calling_object is not passed, then returning