DBA Data[Home] [Help]

APPS.FUN_GL_TRANSFER dependencies on GL_JE_CATEGORIES_TL

Line 271: l_trans_category gl_je_categories_tl.user_je_category_name%TYPE;

267: l_parameter_list WF_PARAMETER_LIST_T :=wf_parameter_list_t();
268: l_event_key VARCHAR2(240);
269: l_initdate date;
270: l_trans_source gl_je_sources_tl.user_je_source_name%TYPE;
271: l_trans_category gl_je_categories_tl.user_je_category_name%TYPE;
272:
273:
274: CURSOR c_dist IS
275: SELECT d.amount_cr, d.amount_dr, d.ccid,

Line 308: select user_je_category_name into l_trans_category from gl_je_categories_tl where

304: /* made changes for 7350856 */
305: select user_je_source_name into l_trans_source from gl_je_sources_tl where
306: je_source_name = p_source and language = USERENV('LANG');
307:
308: select user_je_category_name into l_trans_category from gl_je_categories_tl where
309: je_category_name = p_category and language = USERENV('LANG');
310: /* changes for 7350856 ends */
311:
312: OPEN c_dist;