APPS.AP_UTILITIES_PKG dependencies on AP_ENCUMBRANCE_LINES

Line 3338: | AP_ENCUMBRANCE_LINES_ALL table.

3334: |
3335: | This function is only applicable to pre 11i and 11i data. Due to R12
3336: | new funds/encumbrance solution. AP will be maintaining this function
3337: | for pre-upgrade data because of PSA team decide no upgrade for
3338: | AP_ENCUMBRANCE_LINES_ALL table.
3339: |
3340: | PARAMETERS
3341: | P_Po_distribution_id - po_distribution_id (in)
3342: | P_Start_date - Start gl date (in)

Line 3381: AP_ENCUMBRANCE_LINES ael,

3377:
3378: CURSOR po_enc_reversed_cur IS
3379: SELECT sum(nvl(ael.accounted_cr,0) - nvl(ael.accounted_dr,0) )
3380: FROM AP_INVOICE_DISTRIBUTIONS aid,
3381: AP_ENCUMBRANCE_LINES ael,
3382: financials_system_parameters fsp
3383: WHERE aid.po_distribution_id = P_po_distribution_id
3384: AND aid.invoice_distribution_id = ael.invoice_distribution_id
3385: AND ( ( p_start_gl_date is not null

Line 3421: from ap_encumbrance_lines_all ael

3417: AND (aid.accrual_posted_flag = 'Y' or aid.cash_posted_flag = 'Y')
3418: AND (( p_start_gl_date is not null and p_start_gl_date <= aid.accounting_date) or (p_start_gl_date is null))
3419: AND ((p_end_gl_date is not null and p_end_gl_date >= aid.accounting_date) or (p_end_gl_date is null))
3420: AND NOT EXISTS (SELECT 'release 11.5 encumbrance'
3421: from ap_encumbrance_lines_all ael
3422: where ael.invoice_distribution_id = aid.invoice_distribution_id)
3423: -- bug 7225570
3424: AND aid.bc_event_id is null
3425: AND NOT EXISTS (SELECT 'release 11.5 encumbrance tax'

Line 3426: from ap_encumbrance_lines_all ael

3422: where ael.invoice_distribution_id = aid.invoice_distribution_id)
3423: -- bug 7225570
3424: AND aid.bc_event_id is null
3425: AND NOT EXISTS (SELECT 'release 11.5 encumbrance tax'
3426: from ap_encumbrance_lines_all ael
3427: where ael.invoice_distribution_id = aid.charge_applicable_to_dist_id);
3428:
3429: BEGIN
3430: