DBA Data[Home] [Help]

APPS.JAI_CMN_GL_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 17: CURSOR get_segments_used(coa_id NUMBER,c_flex_code fnd_id_flex_segments.id_flex_code%TYPE ) IS

13: */
14: PROCEDURE get_account_number(p_chart_of_accounts_id IN NUMBER,
15: p_ccid IN NUMBER, p_account_number OUT NOCOPY VARCHAR2) IS
16:
17: CURSOR get_segments_used(coa_id NUMBER,c_flex_code fnd_id_flex_segments.id_flex_code%TYPE ) IS
18: SELECT segment_num, application_column_name
19: FROM fnd_id_flex_segments
20: WHERE id_flex_num = coa_id
21: AND id_flex_code = c_flex_code

Line 19: FROM fnd_id_flex_segments

15: p_ccid IN NUMBER, p_account_number OUT NOCOPY VARCHAR2) IS
16:
17: CURSOR get_segments_used(coa_id NUMBER,c_flex_code fnd_id_flex_segments.id_flex_code%TYPE ) IS
18: SELECT segment_num, application_column_name
19: FROM fnd_id_flex_segments
20: WHERE id_flex_num = coa_id
21: AND id_flex_code = c_flex_code
22: ORDER BY segment_num;
23: