APPS.AP_TRIAL_BALANCE_PKG dependencies on XLA_GL_TRANSFER_BATCHES_ALL

Line 790: gl_transfer_run_id from xla_gl_transfer_batches_all.

786: Logic:
787: ======
788:
789: 1) For a given request_id the function first determines the list of
790: gl_transfer_run_id from xla_gl_transfer_batches_all.
791: 2) Inserts the AP_LIABILITY_BALANCE with the denormalized information
792: from ap_ae_lines_all and ap_ae_headers_all for a given gl_transfer_run_id.
793: 3) Calls the Update trial_balance_flag of ap_ae_headers_all for the same
794: gl_transfer_run_id, so that we can make sure that accounting entry

Line 818: FROM xla_gl_transfer_batches_all xgt,

814: -- Bug 2284841 Code Modified by MSWAMINA.
815:
816: CURSOR transfer_info IS
817: SELECT DISTINCT (xgt.gl_transfer_run_id)
818: FROM xla_gl_transfer_batches_all xgt,
819: ap_ae_headers_all aeh
820: WHERE xgt.gl_transfer_run_id = aeh.gl_transfer_run_id
821: AND xgt.request_id = p_request_id
822: AND nvl(aeh.trial_balance_flag,'N') = 'N';

Line 824: l_gl_transfer_run_id xla_gl_transfer_batches_all.gl_transfer_run_id%TYPE;

820: WHERE xgt.gl_transfer_run_id = aeh.gl_transfer_run_id
821: AND xgt.request_id = p_request_id
822: AND nvl(aeh.trial_balance_flag,'N') = 'N';
823:
824: l_gl_transfer_run_id xla_gl_transfer_batches_all.gl_transfer_run_id%TYPE;
825:
826: BEGIN
827:
828: fnd_file.put_line(fnd_file.log,'Into Insert_AP_Liability_Balance Procedure');