DBA Data[Home] [Help]

APPS.JL_JLZZFIJR_XMLP_PKG dependencies on GL_SETS_OF_BOOKS

Line 18: GL_SETS_OF_BOOKS GSOB

14: GSOB.MRC_SOB_TYPE_CODE,
15: GSOB.CURRENCY_CODE
16: INTO P_MRCSOBTYPE,CP_PARAM_CURRENCY
17: FROM
18: GL_SETS_OF_BOOKS GSOB
19: WHERE GSOB.SET_OF_BOOKS_ID = P_CA_SET_OF_BOOKS_ID;
20: EXCEPTION
21: WHEN OTHERS THEN
22: P_MRCSOBTYPE := 'P';

Line 101: GL_SETS_OF_BOOKS SOB,

97: CUR.PRECISION
98: INTO L_BOOK,L_BOOK_CLASS,L_DISTRIBUTION_SOURCE_BOOK,L_CURRENCY_CODE,L_PRECISION
99: FROM
100: FA_BOOK_CONTROLS_MRC_V BC,
101: GL_SETS_OF_BOOKS SOB,
102: FND_CURRENCIES CUR
103: WHERE BC.BOOK_TYPE_CODE = P_BOOK
104: AND SOB.SET_OF_BOOKS_ID = BC.SET_OF_BOOKS_ID
105: AND SOB.CURRENCY_CODE = CUR.CURRENCY_CODE;

Line 118: GL_SETS_OF_BOOKS SOB,

114: CUR.PRECISION
115: INTO L_BOOK,L_BOOK_CLASS,L_DISTRIBUTION_SOURCE_BOOK,L_CURRENCY_CODE,L_PRECISION
116: FROM
117: FA_BOOK_CONTROLS BC,
118: GL_SETS_OF_BOOKS SOB,
119: FND_CURRENCIES CUR
120: WHERE BC.BOOK_TYPE_CODE = P_BOOK
121: AND SOB.SET_OF_BOOKS_ID = BC.SET_OF_BOOKS_ID
122: AND SOB.CURRENCY_CODE = CUR.CURRENCY_CODE;