DBA Data[Home] [Help]

APPS.AP_UTILITIES_PKG dependencies on GL_JE_BATCHES

Line 2669: FROM gl_je_batches jb

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

Line 2692: FROM gl_je_batches jb

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