DBA Data[Home] [Help]

APPS.PSP_ENC_LIQ_TRAN dependencies on GL_ENCUMBRANCE_TYPES

Line 3286: -- This procedure retrieves the encumbrance_type_id from gl_encumbrance_types

3282: p_return_status := fnd_api.g_ret_sts_unexp_error;
3283: END gl_je_cat;
3284:
3285: -- ##########################################################################
3286: -- This procedure retrieves the encumbrance_type_id from gl_encumbrance_types
3287: -- ##########################################################################
3288:
3289: PROCEDURE enc_type( P_ENCUMBRANCE_TYPE_ID OUT NOCOPY VARCHAR2,
3290: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS

Line 3297: FROM gl_encumbrance_types

3293:
3294: BEGIN
3295: SELECT encumbrance_type_id
3296: INTO p_encumbrance_type_id
3297: FROM gl_encumbrance_types
3298: WHERE encumbrance_type = 'OLD'
3299: AND enabled_flag = 'Y';
3300:
3301: EXCEPTION