4: CURSOR COMPANY(P_COMPANY IN VARCHAR2) IS
5: SELECT
6: SHORT_NAME
7: FROM
8: XTR_PARTIES_V
9: WHERE PARTY_CODE = P_COMPANY;
10: CURSOR CUR_MEAN(P_TYPE IN VARCHAR2,P_CODE IN VARCHAR2) IS
11: SELECT
12: MEANING
75: CP.PARAMETER_VALUE_CODE,
76: DCT.USER_CONVERSION_TYPE,
77: CURRENCY_CODE
78: FROM
79: XTR_PARTIES_V PTY,
80: XTR_COMPANY_PARAMETERS CP,
81: GL_SETS_OF_BOOKS SOB,
82: GL_DAILY_CONVERSION_TYPES DCT
83: WHERE PTY.PARTY_CODE = X_COMPANY_CODE
513: CP.PARAMETER_VALUE_CODE,
514: DCT.USER_CONVERSION_TYPE,
515: CURRENCY_CODE
516: FROM
517: XTR_PARTIES_V PTY,
518: XTR_COMPANY_PARAMETERS CP,
519: GL_SETS_OF_BOOKS SOB,
520: GL_DAILY_CONVERSION_TYPES DCT
521: WHERE PTY.PARTY_CODE = COMPANY_CODE
557: CURSOR COMPANY(P_COMPANY IN VARCHAR2) IS
558: SELECT
559: SHORT_NAME
560: FROM
561: XTR_PARTIES_V
562: WHERE PARTY_CODE = P_COMPANY;
563: L_COMPANY_NAME VARCHAR2(20);
564: BEGIN
565: IF COMPANY_CODE IS NOT NULL THEN