APPS.PA_FUNDS_CONTROL_UTILS dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 2384: FROM ap_invoice_distributions_all aid

2380: p_document_distribution_type IN VARCHAR2 ) RETURN NUMBER IS
2381:
2382: CURSOR C_get_inv_parent_id IS
2383: SELECT AID.Parent_Reversal_id
2384: FROM ap_invoice_distributions_all aid
2385: WHERE aid.invoice_distribution_id = p_document_distribution_id
2386: AND decode(nvl(AID.cancellation_flag,'N'), 'Y', decode(AID.Parent_Reversal_id, null,'N','Y'),'N') = 'Y';
2387:
2388: CURSOR C_get_prepay_parent_id IS

Line 2449: FROM ap_invoice_distributions_all aid

2445: p_invoice_distribution_id IN NUMBER ) RETURN VARCHAR2 IS
2446:
2447: CURSOR C_check_reversing_dist IS
2448: SELECT nvl(AID.cancellation_flag,'N')
2449: FROM ap_invoice_distributions_all aid
2450: WHERE aid.invoice_distribution_id = p_invoice_distribution_id
2451: AND decode(nvl(AID.cancellation_flag,'N'), 'Y', decode(AID.Parent_Reversal_id, null,'N','Y'),'N') = 'Y';
2452:
2453: CURSOR C_check_main_cancelled_dist IS

Line 2457: from ap_invoice_distributions_all aid

2453: CURSOR C_check_main_cancelled_dist IS
2454: SELECT 'Y'
2455: FROM dual
2456: WHERE exists ( select 1
2457: from ap_invoice_distributions_all aid
2458: where aid.invoice_id = p_invoice_id
2459: and aid.Parent_Reversal_id = p_invoice_distribution_id);
2460:
2461: l_ap_sla_reversed_status VARCHAR2(1);