APPS.PA_FUNDS_CONTROL_PKG1 dependencies on GL_ENCUMBRANCE_TYPES

Line 1811: FROM gl_encumbrance_types

1807: CURSOR c_po_details_cur(p_po_distribution_id NUMBER) IS
1808: SELECT po.po_line_id po_line_id,
1809: po.po_header_id ,
1810: (SELECT encumbrance_type_id
1811: FROM gl_encumbrance_types
1812: WHERE encumbrance_type_KEY = 'Obligation') po_encumbrance_type_id ,
1813: po.rate -- Bug 5665232
1814: FROM po_distributions_all po
1815: WHERE po.po_distribution_id = p_po_distribution_id;

Line 2884: FROM gl_encumbrance_types

2880: , NULL) release_id,
2881: -- R12 Funds Management Uptake: Currently this column is not available in AP extract
2882: -- hence added below logic to fetch encumbrance_type_id for invoices
2883: (SELECT encumbrance_type_id
2884: FROM gl_encumbrance_types
2885: WHERE encumbrance_type_KEY = 'Invoices') encumbrance_type_id,
2886: --pa_utils2.get_gl_period_name(apd.accounting_date,apd.org_id)
2887: apext.aid_period_name period_name,
2888: apext.AID_PARENT_REVERSAL_ID parent_reversal_id -- Bug 5406690

Line 2955: FROM gl_encumbrance_types

2951: -- R12 Funds Management Uptake: Currently this column
2952: -- is not available in AP extract
2953: -- hence added below logic to fetch encumbrance_type_id for invoices
2954: (SELECT encumbrance_type_id
2955: FROM gl_encumbrance_types
2956: WHERE encumbrance_type_KEY = 'Invoices') encumbrance_type_id,
2957: AID.PERIOD_NAME period_name,
2958: AID.parent_reversal_id parent_reversal_id -- Bug 5406690
2959: FROM AP_PREPAY_HISTORY_ALL APPH,