APPS.AP_UPDATE_1099_AWT_DISTS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 67: l_type_1099 ap_invoice_distributions.type_1099%TYPE;

63: l_total_count INTEGER := 0;
64: --
65: l_enable_1099_on_awt_flag ap_system_parameters.enable_1099_on_awt_flag%TYPE;
66: l_federal_reportable_flag po_vendors.federal_reportable_flag%TYPE;
67: l_type_1099 ap_invoice_distributions.type_1099%TYPE;
68: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
69: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;
70: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;
71: l_income_tax_region ap_system_parameters.income_tax_region%TYPE;

Line 125: FROM ap_invoice_distributions ID,

121: --
122: SELECT NVL(MIN(invoice_distribution_id),0),
123: NVL(MAX(invoice_distribution_id),0)
124: INTO l_min_invoice_distribution_id, l_max_invoice_distribution_id
125: FROM ap_invoice_distributions ID,
126: ap_invoices AI,
127: po_vendor_sites PVS,
128: po_vendors PV
129: WHERE ID.invoice_id = AI.invoice_id

Line 156: UPDATE ap_invoice_distributions ID

152: --
153: LOOP
154: l_debug_info := 'Update TYPE_1099 on AID';
155: --
156: UPDATE ap_invoice_distributions ID
157: SET ID.type_1099 = 'MISC4',
158: ID.income_tax_Region =
159: decode(l_combined_filing_flag, 'Y',
160: decode(l_income_tax_region_flag, 'Y',