DBA Data[Home] [Help]

APPS.PSP_ENC_SUM_TRAN dependencies on GL_ENCUMBRANCE_TYPES

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

2667: p_return_status := fnd_api.g_ret_sts_unexp_error;
2668: END;
2669:
2670: -- ##########################################################################
2671: -- This procedure retrieves the encumbrance_type_id from gl_encumbrance_types
2672: -- ##########################################################################
2673:
2674: PROCEDURE enc_type( P_ENCUMBRANCE_TYPE_ID OUT NOCOPY VARCHAR2,
2675: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS

Line 2682: FROM gl_encumbrance_types

2678:
2679: BEGIN
2680: SELECT encumbrance_type_id
2681: INTO p_encumbrance_type_id
2682: FROM gl_encumbrance_types
2683: WHERE encumbrance_type = 'OLD'
2684: AND enabled_flag = 'Y';
2685:
2686: EXCEPTION