APPS.PSP_ENC_SUM_TRAN dependencies on GL_JE_CATEGORIES

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

2598: p_return_status := fnd_api.g_ret_sts_unexp_error;
2599: END;
2600:
2601: -- ##########################################################################
2602: -- This procedure retrieves the user_je_category_name from gl_je_categories
2603: -- ##########################################################################
2604:
2605: PROCEDURE gl_je_cat( P_USER_JE_CATEGORY_NAME OUT NOCOPY VARCHAR2,
2606: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS

Line 2612: FROM gl_je_categories

2608: l_product VARCHAR2(3);
2609: BEGIN
2610: SELECT user_je_category_name
2611: INTO p_user_je_category_name
2612: FROM gl_je_categories
2613: WHERE je_category_name = 'OLD';
2614: EXCEPTION
2615: WHEN NO_DATA_FOUND THEN
2616: l_error := 'JE CATEGORY = OLD';