APPS.AP_INVOICES_PKG dependencies on AP_INVOICE_LINES_ALL

Line 2950: from ap_invoice_lines_all

2946: SUM(decode(wfapproval_status,'NEEDS WFREAPPROVAL',1,0)) , /* Bug 11655111 */
2947: SUM(decode(wfapproval_status,'REJECTED',1,0)),
2948: SUM(decode(wfapproval_status,'INITIATED',1,0))
2949: into l_not_required,l_approved,l_reapprove,l_rejected, l_initiated
2950: from ap_invoice_lines_all
2951: where invoice_id=p_invoice_id
2952: and org_id=p_org_id;
2953: --group by wfapproval_status;
2954:

Line 3413: FROM ap_invoice_lines_all ail

3409: INTO l_invoice_includes_prepay_flag
3410: FROM ap_invoices_all ai
3411: WHERE ai.invoice_id = P_invoice_id
3412: AND EXISTS (SELECT ail.invoice_includes_prepay_flag
3413: FROM ap_invoice_lines_all ail
3414: WHERE ail.invoice_id = ai.invoice_id
3415: AND ail.invoice_includes_prepay_flag = 'Y');
3416:
3417: IF(l_invoice_includes_prepay_flag is NULL) THEN

Line 3422: FROM ap_invoice_lines_all ail

3418: RETURN NULL;
3419: ELSE
3420: SELECT SUM(NVL(ail.amount,0))
3421: INTO l_total
3422: FROM ap_invoice_lines_all ail
3423: WHERE ail.invoice_id = P_invoice_id
3424: AND (ail.line_type_lookup_code NOT IN ('PREPAY', 'AWT')
3425: AND ail.prepay_invoice_id IS NULL
3426: AND ail.prepay_line_number IS NULL);

Line 3456: FROM AP_INVOICE_LINES_ALL AIL

3452: AND ai.payment_status_flag = 'Y'
3453: AND NVL(ai.force_revalidation_flag,'N') = 'N'
3454: AND EXISTS
3455: (SELECT 1
3456: FROM AP_INVOICE_LINES_ALL AIL
3457: WHERE AIL.INVOICE_ID = AI.INVOICE_ID
3458: AND NVL(AIL.DISCARDED_FLAG, 'N') <> 'Y'
3459: AND NVL(AIL.CANCELLED_FLAG, 'N') <> 'Y'
3460: AND (AIL.AMOUNT <> 0