APPS.PA_FUNDS_CONTROL_PKG1 dependencies on GL_ENCUMBRANCE_TYPES

Line 1857: FROM gl_encumbrance_types

1853: CURSOR c_po_details_cur(p_po_distribution_id NUMBER) IS
1854: SELECT po.po_line_id po_line_id,
1855: po.po_header_id ,
1856: (SELECT encumbrance_type_id
1857: FROM gl_encumbrance_types
1858: WHERE encumbrance_type_KEY = 'Obligation') po_encumbrance_type_id ,
1859: po.rate -- Bug 5665232
1860: FROM po_distributions_all po
1861: WHERE po.po_distribution_id = p_po_distribution_id;

Line 2989: FROM gl_encumbrance_types

2985: , NULL) release_id,
2986: -- R12 Funds Management Uptake: Currently this column is not available in AP extract
2987: -- hence added below logic to fetch encumbrance_type_id for invoices
2988: (SELECT encumbrance_type_id
2989: FROM gl_encumbrance_types
2990: WHERE encumbrance_type_KEY = 'Invoices') encumbrance_type_id,
2991: --pa_utils2.get_gl_period_name(apd.accounting_date,apd.org_id)
2992: apext.aid_period_name period_name,
2993: apext.AID_PARENT_REVERSAL_ID parent_reversal_id -- Bug 5406690

Line 3154: FROM gl_encumbrance_types

3150: -- R12 Funds Management Uptake: Currently this column
3151: -- is not available in AP extract
3152: -- hence added below logic to fetch encumbrance_type_id for invoices
3153: (SELECT encumbrance_type_id
3154: FROM gl_encumbrance_types
3155: WHERE encumbrance_type_KEY = 'Invoices') encumbrance_type_id,
3156: AID.PERIOD_NAME period_name,
3157: AID.parent_reversal_id parent_reversal_id -- Bug 5406690
3158: FROM AP_PREPAY_HISTORY_ALL APPH,

Line 3218: FROM gl_encumbrance_types

3214: AID.ACCOUNTING_DATE gl_date,
3215: APAD.prepay_dist_lookup_code distribution_type,
3216: AIL.po_release_id release_id,
3217: (SELECT encumbrance_type_id
3218: FROM gl_encumbrance_types
3219: WHERE encumbrance_type_KEY = 'Invoices') encumbrance_type_id,
3220: AID.PERIOD_NAME period_name,
3221: AID.parent_reversal_id parent_reversal_id
3222: FROM AP_PREPAY_HISTORY_ALL APPH,