APPS.AP_ACCOUNTING_UTILITIES_PKG dependencies on AP_ENCUMBRANCE_LINES

Line 55: AP_ENCUMBRANCE_LINES ael,

51:
52: CURSOR po_enc_reversed_cur IS
53: SELECT sum(nvl(ael.accounted_cr,0) - nvl(ael.accounted_dr,0))
54: FROM AP_INVOICE_DISTRIBUTIONS aid,
55: AP_ENCUMBRANCE_LINES ael,
56: financials_system_parameters fsp
57: WHERE aid.po_distribution_id = P_po_distribution_id
58: AND aid.invoice_distribution_id = ael.invoice_distribution_id
59: AND ( ( p_start_gl_date is not null

Line 102: from ap_encumbrance_lines_all ael

98: AND (aid.accrual_posted_flag = 'Y' or aid.cash_posted_flag = 'Y')
99: AND (( p_start_gl_date is not null and p_start_gl_date <= aid.accounting_date) or (p_start_gl_date is null))
100: AND ((p_end_gl_date is not null and p_end_gl_date >= aid.accounting_date) or (p_end_gl_date is null))
101: AND NOT EXISTS (SELECT 'release 11.5 encumbrance'
102: from ap_encumbrance_lines_all ael
103: where ael.invoice_distribution_id = aid.invoice_distribution_id);
104:
105:
106: