APPS.AP_WITHHOLDING_PKG dependencies on AP_AWT_TEMP_DISTRIBUTIONS_ALL

Line 65: FROM ap_awt_temp_distributions_all AATD,

61: , AI.org_id
62: , AATD.awt_related_id
63: , aatd.checkrun_id
64: , TC.description --Bug5502917
65: FROM ap_awt_temp_distributions_all AATD,
66: ap_invoices_all AI,
67: ap_tax_codes_all TC
68: WHERE AATD.invoice_id = InvId
69: AND AATD.invoice_id = AI.invoice_id

Line 514: DELETE ap_awt_temp_distributions_all

510: -- delete temp withholding lines for thIS invoice
511:
512: debug_info := 'Delete From ap_awt_temp_distributions';
513:
514: DELETE ap_awt_temp_distributions_all
515: WHERE invoice_id = p_invoice_id
516: AND (P_Payment_Num IS NULL OR payment_num = P_Payment_Num);
517:
518: <>

Line 2220: FROM ap_awt_temp_distributions_all AATD

2216:
2217: debug_info := 'Select sum of withholding amount for thIS invoice';
2218: SELECT NVL(SUM(AATD.withholding_amount), 0)
2219: INTO l_withholding_amount
2220: FROM ap_awt_temp_distributions_all AATD
2221: WHERE AATD.checkrun_name = P_Checkrun_Name
2222: AND AATD.invoice_id = rec_ok_sel_invs.invoice_id
2223: AND AATD.payment_num = rec_ok_sel_invs.payment_num
2224: and aatd.checkrun_id = p_checkrun_id;

Line 2560: FROM ap_awt_temp_distributions_all AATD,

2556: , AATD.checkrun_name
2557: , AATD.tax_rate_id
2558: , TC.tax_id tax_code_id
2559: , aatd.checkrun_id
2560: FROM ap_awt_temp_distributions_all AATD,
2561: ap_invoices_all AI,
2562: ap_tax_codes_all TC
2563: WHERE AATD.invoice_id = InvId
2564: AND AATD.invoice_id = AI.invoice_id

Line 2743: DELETE ap_awt_temp_distributions_all

2739: END IF;
2740: -- Drop that temporary line:
2741: debug_info := 'Delete the AWT temp distribution';
2742:
2743: DELETE ap_awt_temp_distributions_all
2744: WHERE invoice_id = rec_temp.invoice_id
2745: AND group_id = rec_temp.group_id
2746: AND tax_name = rec_temp.tax_name
2747: AND ( ( (checkrun_name = NVL(rec_temp.checkrun_name, checkrun_name))