APPS.AP_CALC_WITHHOLDING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 354: FROM ap_invoice_distributions AID

350: IS
351: SELECT (aid.amount * Withheld_amt / proration_divisor) prorated_awt_amt,
352: (NVL(aid.base_amount,amount) * Withheld_amt/ proration_base_divisor) prorated_base_awt_amt,
353: invoice_distribution_id
354: FROM ap_invoice_distributions AID
355: WHERE aid.invoice_id = p_invoice_id
356: --Bug 7217385 modified the below line
357: --AND aid.line_type_lookup_code NOT IN ('AWT','PREPAY')
358: AND aid.line_type_lookup_code <> 'AWT'

Line 425: FROM ap_invoice_distributions AID

421: SELECT SUM(NVL(AID.amount,0)),
422: SUM(NVL(NVL(AID.base_amount,aid.amount),0))
423: INTO l_proration_divisor,
424: l_proration_base_divisor
425: FROM ap_invoice_distributions AID
426: WHERE aid.invoice_id = Invoiceid
427: --Bug 7217385 modified the below line
428: --AND aid.line_type_lookup_code NOT IN ('AWT','PREPAY')
429: AND aid.line_type_lookup_code <> 'AWT'

Line 913: gl_period_name ap_invoice_distributions.period_name%TYPE;

909: invoice_number ap_invoices.invoice_num%TYPE;
910: supplier_id ap_invoices.vendor_id%TYPE;
911: supplier_site_id ap_invoices.vendor_site_id%TYPE;
912: NUMBER_of_awt_groups integer := 0;
913: gl_period_name ap_invoice_distributions.period_name%TYPE;
914: gl_awt_date DATE;
915:
916: -- Invalid Situations Variables
917: invalid_group ap_awt_groups.group_id%TYPE;

Line 1863: from ap_invoice_distributions_all AID,ap_system_parameters_all AIP

1859: FROM (select DECODE(AIP.create_awt_dists_type,'BOTH',decode(p_calling_module,'AUTOAPPROVAL',
1860: AID.awt_group_id,AID.pay_awt_group_id),
1861: 'PAYMENT',AID.pay_awt_group_id,AID.awt_group_id) group_id,
1862: AID.amount,AID.base_amount,AID.line_type_lookup_code
1863: from ap_invoice_distributions_all AID,ap_system_parameters_all AIP
1864: where AID.invoice_id = InvId
1865: AND AID.org_id = AIP.org_id ) D,
1866: ap_awt_groups G
1867: where D.group_id = G.group_id(+)