APPS.JA_JAINRECI_XMLP_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 193: ORG_ORGANIZATION_DEFINITIONS

189: WHERE SET_OF_BOOKS_ID in (
190: SELECT
191: SET_OF_BOOKS_ID
192: FROM
193: ORG_ORGANIZATION_DEFINITIONS
194: WHERE ORGANIZATION_ID = ORGANIZATION_ID1 )) LOOP
195: V_CURRENCY_CODE := FETCH_CURR_CODE.CURRENCY_CODE;
196: END LOOP;
197: RETURN (V_CURRENCY_CODE);

Line 204: V_ORGANIZATION_NAME ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;

200: RETURN (NULL);
201: END CF_CURRENCY_CODEFORMULA;
202:
203: FUNCTION CF_ORGANIZATION_NAMEFORMULA(ORGANIZATION_ID1 IN NUMBER) RETURN CHAR IS
204: V_ORGANIZATION_NAME ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;
205: BEGIN
206: FOR fetch_org_name IN (SELECT
207: ORGANIZATION_NAME
208: FROM

Line 209: ORG_ORGANIZATION_DEFINITIONS

205: BEGIN
206: FOR fetch_org_name IN (SELECT
207: ORGANIZATION_NAME
208: FROM
209: ORG_ORGANIZATION_DEFINITIONS
210: WHERE ORGANIZATION_ID = ORGANIZATION_ID1) LOOP
211: V_ORGANIZATION_NAME := FETCH_ORG_NAME.ORGANIZATION_NAME;
212: END LOOP;
213: RETURN (V_ORGANIZATION_NAME);