DBA Data[Home] [Help]

APPS.PSP_ENC_LIQ_TRAN dependencies on GL_JE_CATEGORIES

Line 3258: -- This procedure retrieves the user_je_category_name from gl_je_categories

3254: p_return_status := fnd_api.g_ret_sts_unexp_error;
3255: END gl_je_source;
3256:
3257: -- ##########################################################################
3258: -- This procedure retrieves the user_je_category_name from gl_je_categories
3259: -- ##########################################################################
3260:
3261: PROCEDURE gl_je_cat( P_USER_JE_CATEGORY_NAME OUT NOCOPY VARCHAR2,
3262: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS

Line 3268: FROM gl_je_categories

3264: l_product VARCHAR2(3);
3265: BEGIN
3266: SELECT user_je_category_name
3267: INTO p_user_je_category_name
3268: FROM gl_je_categories
3269: WHERE je_category_name = 'OLD';
3270: EXCEPTION
3271: WHEN NO_DATA_FOUND THEN
3272: l_error := 'JE CATEGORY = OLD';