DBA Data[Home] [Help]

APPS.PSP_ENC_SUM_TRAN dependencies on GL_ENCUMBRANCE_TYPES

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

2626: p_return_status := fnd_api.g_ret_sts_unexp_error;
2627: END;
2628:
2629: -- ##########################################################################
2630: -- This procedure retrieves the encumbrance_type_id from gl_encumbrance_types
2631: -- ##########################################################################
2632:
2633: PROCEDURE enc_type( P_ENCUMBRANCE_TYPE_ID OUT NOCOPY VARCHAR2,
2634: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS

Line 2641: FROM gl_encumbrance_types

2637:
2638: BEGIN
2639: SELECT encumbrance_type_id
2640: INTO p_encumbrance_type_id
2641: FROM gl_encumbrance_types
2642: WHERE encumbrance_type = 'OLD'
2643: AND enabled_flag = 'Y';
2644:
2645: EXCEPTION