DBA Data[Home] [Help]

APPS.AP_UTILITIES_PKG dependencies on GL_JE_BATCHES

Line 2674: FROM gl_je_batches jb

2670: IF P_batch_id = -999 and P_gl_sl_link_id is not NULL THEN
2671: BEGIN
2672: /* Definitely a Batch Name is avaialble with the LINK */
2673: SELECT jb.name INTO ret_val
2674: FROM gl_je_batches jb
2675: WHERE JB.je_batch_id IN (SELECT IR.je_batch_id
2676: FROM gl_import_references IR
2677: WHERE IR.gl_sl_link_id = P_GL_SL_link_id
2678: AND IR.gl_sl_link_table = 'APECL');

Line 2697: FROM gl_je_batches jb

2693: return '-999';
2694: ELSE
2695: /* The Batch Name is Provided */
2696: SELECT jb.name INTO ret_val
2697: FROM gl_je_batches jb
2698: WHERE JB.je_batch_id = P_batch_id
2699: and P_GL_SL_link_id IN
2700: (SELECT IR.gl_sl_link_id
2701: FROM gl_import_references IR, gl_je_headers JEH