APPS.GMS_FUNDS_CONTROL_PKG dependencies on GL_ENCUMBRANCE_TYPES

Line 8200: gl_encumbrance_types glet

8196: glbc.accounted_dr entered_dr , -- Bug 5614467
8197: glbc.accounted_cr entered_cr, -- Bug 5614467
8198: source_distribution_type
8199: from gl_bc_packets glbc,
8200: gl_encumbrance_types glet
8201: where glbc.packet_id = p_packet_id
8202: and glbc.encumbrance_type_id = glet.encumbrance_type_id;
8203:
8204: l_dist_id pa_bc_packets.document_header_id%type;

Line 8222: /* Bug 5250793 : Added a join with gl_encumbrance_types so that the gl_bc_packets_rowid on gms_bc_packets is updated

8218: IF g_debug = 'Y' THEN
8219: gms_error_pkg.gms_debug ('Synch_gms_gl_packets Strat : Previously establised packet is = '|| l_gms_packet_id,'C');
8220: END IF;
8221:
8222: /* Bug 5250793 : Added a join with gl_encumbrance_types so that the gl_bc_packets_rowid on gms_bc_packets is updated
8223: correctly for an invoice matched to a PO scenario. Before this change , the same gl_bc_packets_rowid was updated on
8224: gms_bc_packets for both the PO reversal and AP reserve records irrespective of the corresponding rowid on gl_bc_packets.*/
8225:
8226: -- Update gms_bc_packets data

Line 8356: FROM gl_encumbrance_types glenc

8352: where glbc.packet_id = p_packet_id
8353: and glbc.event_id = gbc.source_event_id
8354: and glbc.source_distribution_id_num_1 <> gbc.document_distribution_id
8355: and glbc.encumbrance_type_id IN (SELECT glenc.encumbrance_type_id --Seeded encumbrance type for PO
8356: FROM gl_encumbrance_types glenc
8357: WHERE glenc.encumbrance_type_key = 'Obligation')
8358: and rownum = 1)
8359: where gbc.packet_id = l_gms_packet_id
8360: and gbc.status_code = 'I'