DBA Data[Home] [Help]

APPS.XTR_XTRDDHTY_XMLP_PKG dependencies on XTR_PARTIES_V

Line 104: XTR_PARTIES_V

100: CURSOR COMPANY(P_COMPANY IN VARCHAR2) IS
101: SELECT
102: SHORT_NAME
103: FROM
104: XTR_PARTIES_V
105: WHERE PARTY_CODE = P_COMPANY;
106: CURSOR STRATEGY(P_STRATEGY IN VARCHAR2) IS
107: SELECT
108: STRATEGY_NAME

Line 205: XTR_PARTIES_V PTY,

201: CP.PARAMETER_VALUE_CODE,
202: DCT.USER_CONVERSION_TYPE,
203: CURRENCY_CODE
204: FROM
205: XTR_PARTIES_V PTY,
206: XTR_COMPANY_PARAMETERS CP,
207: GL_SETS_OF_BOOKS SOB,
208: GL_DAILY_CONVERSION_TYPES DCT
209: WHERE PTY.PARTY_CODE = X_COMPANY_CODE

Line 354: XTR_PARTIES_V

350: CURSOR COMPANY(P_COMPANY IN VARCHAR2) IS
351: SELECT
352: SHORT_NAME
353: FROM
354: XTR_PARTIES_V
355: WHERE PARTY_CODE = P_COMPANY;
356: L_COMPANY VARCHAR2(20);
357: BEGIN
358: IF COMPANY_CODE IS NOT NULL THEN

Line 481: XTR_PARTIES_V PTY,

477: CP.PARAMETER_VALUE_CODE,
478: DCT.USER_CONVERSION_TYPE,
479: CURRENCY_CODE
480: FROM
481: XTR_PARTIES_V PTY,
482: XTR_COMPANY_PARAMETERS CP,
483: GL_SETS_OF_BOOKS SOB,
484: GL_DAILY_CONVERSION_TYPES DCT
485: WHERE PTY.PARTY_CODE = COMPANY_CODE