APPS.XTR_XTROHINS_XMLP_PKG dependencies on XTR_PARTIES_V

Line 8: XTR_PARTIES_V

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

Line 79: XTR_PARTIES_V PTY,

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

Line 517: XTR_PARTIES_V PTY,

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

Line 561: XTR_PARTIES_V

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