DBA Data[Home] [Help]

APPS.IGS_FI_GEN_007 dependencies on GL_CODE_COMBINATIONS_KFV

Line 1203: FROM gl_code_combinations_kfv

1199:
1200: -- Cursor for fetching the Concatenated Segments for the CCID passed as input to the function
1201: CURSOR cur_gl_ccid(cp_ccid NUMBER) IS
1202: SELECT concatenated_segments
1203: FROM gl_code_combinations_kfv
1204: WHERE code_combination_id = cp_ccid;
1205:
1206: l_ccid_concat gl_code_combinations_kfv.concatenated_segments%TYPE;
1207: BEGIN

Line 1206: l_ccid_concat gl_code_combinations_kfv.concatenated_segments%TYPE;

1202: SELECT concatenated_segments
1203: FROM gl_code_combinations_kfv
1204: WHERE code_combination_id = cp_ccid;
1205:
1206: l_ccid_concat gl_code_combinations_kfv.concatenated_segments%TYPE;
1207: BEGIN
1208:
1209: -- If the p_ccid is passed as NULL, then return NULL
1210: IF p_ccid IS NULL THEN

Line 1216: -- Fetch the Concatenated Segments from the GL_CODE_COMBINATIONS_KFV view

1212:
1213: -- Else
1214: ELSE
1215:
1216: -- Fetch the Concatenated Segments from the GL_CODE_COMBINATIONS_KFV view
1217: OPEN cur_gl_ccid(p_ccid);
1218: FETCH cur_gl_ccid INTO l_ccid_concat;
1219: IF cur_gl_ccid%NOTFOUND THEN
1220: l_ccid_concat := NULL;