APPS.PA_FUNDS_CONTROL_UTILS dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 2535: FROM ap_invoice_distributions_all aid

2531: p_document_distribution_type IN VARCHAR2 ) RETURN NUMBER IS
2532:
2533: CURSOR C_get_inv_parent_id IS
2534: SELECT AID.Parent_Reversal_id
2535: FROM ap_invoice_distributions_all aid
2536: WHERE aid.invoice_distribution_id = p_document_distribution_id
2537: AND decode(nvl(AID.cancellation_flag,'N'), 'Y', decode(AID.Parent_Reversal_id, null,'N','Y'),'N') = 'Y';
2538:
2539: CURSOR C_get_prepay_parent_id IS

Line 2600: FROM ap_invoice_distributions_all aid

2596: p_invoice_distribution_id IN NUMBER ) RETURN VARCHAR2 IS
2597:
2598: CURSOR C_check_reversing_dist IS
2599: SELECT nvl(AID.cancellation_flag,'N')
2600: FROM ap_invoice_distributions_all aid
2601: WHERE aid.invoice_distribution_id = p_invoice_distribution_id
2602: AND decode(nvl(AID.cancellation_flag,'N'), 'Y', decode(AID.Parent_Reversal_id, null,'N','Y'),'N') = 'Y';
2603:
2604: CURSOR C_check_main_cancelled_dist IS

Line 2608: from ap_invoice_distributions_all aid

2604: CURSOR C_check_main_cancelled_dist IS
2605: SELECT 'Y'
2606: FROM dual
2607: WHERE exists ( select 1
2608: from ap_invoice_distributions_all aid
2609: where aid.invoice_id = p_invoice_id
2610: and aid.Parent_Reversal_id = p_invoice_distribution_id);
2611:
2612: l_ap_sla_reversed_status VARCHAR2(1);