APPS.JAI_CMN_UTILS_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

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

127: IS
128: /* Bug 5243532. Added by Lakshmi Gopalsami
129: Removed the cursor c_set_of_books and c_operating_unit
130: which is referring to hr_operating_units
131: and org_organization_definitions. Replaced the same with caching logic.
132: Replaced gl_sets_of_books with gl_ledgers
133: */
134: CURSOR c_sob_currency (cp_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE) IS
135: SELECT currency_code

Line 216: p_inventory_orgn_id ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_ID%TYPE

212: END return_valid_date;
213:
214: FUNCTION get_operating_unit (
215: p_calling_object VARCHAR2 ,
216: p_inventory_orgn_id ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_ID%TYPE
217: ) RETURN NUMBER
218: IS
219: CURSOR c_operating_unit IS
220: SELECT operating_unit

Line 221: FROM org_organization_definitions

217: ) RETURN NUMBER
218: IS
219: CURSOR c_operating_unit IS
220: SELECT operating_unit
221: FROM org_organization_definitions
222: WHERE organization_id = p_inventory_orgn_id;
223:
224: ln_operating_unit_id ORG_ORGANIZATION_DEFINITIONS.OPERATING_UNIT%TYPE;
225:

Line 224: ln_operating_unit_id ORG_ORGANIZATION_DEFINITIONS.OPERATING_UNIT%TYPE;

220: SELECT operating_unit
221: FROM org_organization_definitions
222: WHERE organization_id = p_inventory_orgn_id;
223:
224: ln_operating_unit_id ORG_ORGANIZATION_DEFINITIONS.OPERATING_UNIT%TYPE;
225:
226: BEGIN
227: /*
228: || If the mandatory parameter p_calling_object is not passed, then returning