DBA Data[Home] [Help]

APPS.FA_MASS_TRANSFERS_PKG dependencies on GL_CODE_COMBINATIONS

Line 67: from gl_code_combinations glcc,

63:
64:
65: CURSOR C_glcc IS
66: select nvl(glcc.code_combination_id, -99)
67: from gl_code_combinations glcc,
68: ( select * from gl_code_combinations
69: where code_combination_id = x_from_glccid ) from_glcc
70: where glcc.segment1 = nvl(mtfr_rec.segment1, from_glcc.segment1)
71: and glcc.segment2 = nvl(mtfr_rec.segment2, from_glcc.segment2)

Line 68: ( select * from gl_code_combinations

64:
65: CURSOR C_glcc IS
66: select nvl(glcc.code_combination_id, -99)
67: from gl_code_combinations glcc,
68: ( select * from gl_code_combinations
69: where code_combination_id = x_from_glccid ) from_glcc
70: where glcc.segment1 = nvl(mtfr_rec.segment1, from_glcc.segment1)
71: and glcc.segment2 = nvl(mtfr_rec.segment2, from_glcc.segment2)
72: and glcc.segment3 = nvl(mtfr_rec.segment3, from_glcc.segment3)