APPS.JAI_AP_MISC_PKG dependencies on JAI_AP_MATCH_INV_TAXES

Line 105: from JAI_AP_MATCH_INV_TAXES

101: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| p_invoice_id);
102: fnd_file.put_line(FND_FILE.LOG, ' po dist id '|| p_po_dist_id);
103:
104: for Misc_loop in ( select *
105: from JAI_AP_MATCH_INV_TAXES
106: where invoice_id = p_invoice_id
107: and parent_invoice_distribution_id = p_invoice_distribution_id
108: )
109: loop

Line 118: from JAI_AP_MATCH_INV_TAXES

114: /* For later use if necessary to check the tax type. now education cess will not be
115: created at invoice level if it is available in PO/Receipt level
116:
117: for tax_loop in check_rec_tax (select tax_id
118: from JAI_AP_MATCH_INV_TAXES
119: where invoice_id = misc_loop.invoice_id
120: and distribution_line_number = misc_loop.distribution_line_number)
121: loop
122:

Line 253: from JAI_AP_MATCH_INV_TAXES

249: IS
250: cursor c_line_amt
251: is
252: select NVL(SUM(tax_amount),-1) -- 5763527, Added SUM as partially recoverable taxes will have two lines
253: from JAI_AP_MATCH_INV_TAXES
254: where invoice_id = p_invoice_id
255: and line_no = p_precedence_value ;
256:
257: cursor c_base_inv_amt