APPS.AP_UTILITIES_PKG dependencies on AP_ENCUMBRANCE_LINES_ALL

Line 3368: | AP_ENCUMBRANCE_LINES_ALL table.

3364: |
3365: | This function is only applicable to pre 11i and 11i data. Due to R12
3366: | new funds/encumbrance solution. AP will be maintaining this function
3367: | for pre-upgrade data because of PSA team decide no upgrade for
3368: | AP_ENCUMBRANCE_LINES_ALL table.
3369: |
3370: | PARAMETERS
3371: | P_Po_distribution_id - po_distribution_id (in)
3372: | P_Start_date - Start gl date (in)

Line 3463: from ap_encumbrance_lines_all ael

3459: AND (aid.accrual_posted_flag = 'Y' or aid.cash_posted_flag = 'Y')
3460: AND (( p_start_gl_date is not null and p_start_gl_date <= aid.accounting_date) or (p_start_gl_date is null))
3461: AND ((p_end_gl_date is not null and p_end_gl_date >= aid.accounting_date) or (p_end_gl_date is null))
3462: AND NOT EXISTS (SELECT 'release 11.5 encumbrance'
3463: from ap_encumbrance_lines_all ael
3464: where ael.invoice_distribution_id = aid.invoice_distribution_id)
3465: -- bug 7225570
3466: AND aid.bc_event_id is null
3467: AND NOT EXISTS (SELECT 'release 11.5 encumbrance tax'

Line 3468: from ap_encumbrance_lines_all ael

3464: where ael.invoice_distribution_id = aid.invoice_distribution_id)
3465: -- bug 7225570
3466: AND aid.bc_event_id is null
3467: AND NOT EXISTS (SELECT 'release 11.5 encumbrance tax'
3468: from ap_encumbrance_lines_all ael
3469: where ael.invoice_distribution_id = aid.charge_applicable_to_dist_id);
3470:
3471: BEGIN
3472: