APPS.AP_WITHHOLDING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 339: INSERT INTO ap_invoice_distributions_all (

335: rec_temp_dists.org_id, --7230158
336: decode (rec_temp_dists.invoice_payment_id,NULL,NULL,rec_temp_dists.group_id)); --7230158
337: debug_info := 'Insert INTO ap_invoice_distributions';
338:
339: INSERT INTO ap_invoice_distributions_all (
340: accounting_date
341: ,accrual_posted_flag
342: ,assets_addition_flag
343: ,assets_tracking_flag

Line 778: FROM ap_invoice_distributions_all APID,

774: , APID.batch_id batch_id
775: --, APID.ussgl_transaction_code ussgl_transaction_code - Bug 4277744
776: --, APID.ussgl_trx_code_context ussgl_trx_code_context - Bug 4277744
777: , APID.org_id
778: FROM ap_invoice_distributions_all APID,
779: ap_tax_codes_all ATC,
780: ap_invoices_all AI
781: WHERE (APID.invoice_id = InvId)
782: AND (APID.invoice_line_number = NVL(P_Inv_Line_No,invoice_line_number))

Line 1242: INSERT INTO ap_invoice_distributions_all (

1238: INTO l_invoice_distribution_id
1239: FROM DUAL;
1240:
1241:
1242: INSERT INTO ap_invoice_distributions_all (
1243: accounting_date
1244: ,accrual_posted_flag
1245: ,assets_addition_flag
1246: ,assets_tracking_flag

Line 1431: UPDATE ap_invoice_distributions_all

1427: -- End: Update original negative distribution with new invoice id:
1428:
1429: debug_info := 'Update ap_invoice_distributions';
1430:
1431: UPDATE ap_invoice_distributions_all
1432: SET awt_invoice_id = new_invoice_id
1433: WHERE current of c_awt_lines;
1434:
1435: END LOOP For_Each_Negative_Line;