APPS.AP_UTILITIES_PKG dependencies on GL_IMPORT_REFERENCES

Line 2671: FROM gl_import_references IR

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');
2674: EXCEPTION
2675: WHEN NO_DATA_FOUND THEN

Line 2681: FROM gl_import_references IR

2677: want such rows */
2678: SELECT '-999' into ret_val
2679: FROM DUAL
2680: WHERE NOT EXISTS (SELECT 'this link id exists in IR'
2681: FROM gl_import_references IR
2682: WHERE IR.gl_sl_link_id=P_gl_sl_link_id
2683: AND IR.gl_sl_link_table = 'APECL');
2684: END;
2685: RETURN ret_val;

Line 2696: FROM gl_import_references IR, gl_je_headers JEH

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
2697: WHERE IR.je_header_id = JEH.je_header_id
2698: AND JEH.ledger_id = P_Ledger_id
2699: AND JEH.je_batch_id = P_batch_id
2700: AND IR.gl_sl_link_table = 'APECL');