APPS.AP_UTILITIES_PKG dependencies on GL_IMPORT_REFERENCES

Line 2676: FROM gl_import_references IR

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

Line 2686: FROM gl_import_references IR

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

Line 2701: FROM gl_import_references IR, gl_je_headers JEH

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
2702: WHERE IR.je_header_id = JEH.je_header_id
2703: AND JEH.ledger_id = P_Ledger_id
2704: AND JEH.je_batch_id = P_batch_id
2705: AND IR.gl_sl_link_table = 'APECL');