APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on AP_AWT_TEMP_DISTRIBUTIONS

Line 5094: ap_awt_temp_distributions awtd

5090: SELECT count(*)
5091: INTO l_count_inv
5092: FROM iby_hook_docs_in_pmt_t docs,
5093: -- RG ap_selected_invoices apsi,
5094: ap_awt_temp_distributions awtd
5095: WHERE docs.payment_id = P_Selected_Check_Id
5096: AND nvl(docs.dont_pay_flag,'N') ='N'
5097: AND docs.calling_app_doc_unique_ref2 = awtd.invoice_id
5098: AND docs.calling_app_id=200 ;

Line 5188: FROM ap_awt_temp_distributions

5184: -----------------------------------------------------
5185:
5186: SELECT nvl(sum(withholding_amount), 0)
5187: INTO l_withholding_amount
5188: FROM ap_awt_temp_distributions
5189: WHERE checkrun_name = P_Checkrun_Name
5190: AND checkrun_id= p_checkrun_id
5191: AND invoice_id = rec_sel_inv.invoice_id
5192: AND payment_num = rec_sel_inv.payment_num;

Line 5390: FROM ap_awt_temp_distributions apatd

5386: -- Checks for temporary distribution lines
5387: -------------------------------------------
5388: SELECT count('Withholding Already Calculated')
5389: INTO l_count
5390: FROM ap_awt_temp_distributions apatd
5391: WHERE apatd.invoice_id = P_Invoice_Id
5392: AND apatd.tax_name = P_Tax_Name;
5393:
5394: IF (nvl(l_count, 0) > 0) THEN