DBA Data[Home] [Help]

APPS.AP_CALC_WITHHOLDING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

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(+)