APPS.AP_PAY_INVOICE_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 1097: FROM ap_invoice_distributions AID

1093:
1094: debug_info := 'Query for prepay applied';
1095: SELECT DECODE( NVL( SUM(AID.amount), 0 ), 0, 'N', 'Y' )
1096: INTO l_prepay_applied
1097: FROM ap_invoice_distributions AID
1098: WHERE AID.invoice_id = p_invoice_id
1099: AND AID.line_type_lookup_code = 'PREPAY';
1100:
1101: /* This is written in separate steps so we can use the following