APPS.JAI_AP_IDA_TRIGGER_DTC_PKG dependencies on JAI_RCV_LINE_TAXES

Line 87: FROM JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b

83: AND trunc (p_inv_date) between start_date and end_date ; -- Modified by Jia for FP Bug#8656402, change sysdate to p_inv_date
84: /*START, by amandali for Bug#10430662*/
85: cursor c_receipt_wct_tax(p_shipment_line_id number) is
86: select a.tax_id
87: FROM JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b
88: where a.tax_id = b.tax_id
89: and a.shipment_line_id = p_shipment_line_id
90: and a.tax_type = 'TDS'
91: and b.section_type= 'WCT_SECTION';

Line 278: (nvl(jct.adhoc_flag,'Q')='Y' and exists (select '1' from jai_rcv_line_taxes jpt

274: and jpt.currency=jm.currency_code
275: AND jpt.tax_id=jm.tax_id)
276: )
277: OR
278: (nvl(jct.adhoc_flag,'Q')='Y' and exists (select '1' from jai_rcv_line_taxes jpt
279: where jpt.shipment_header_id=jm.shipment_header_id
280: and jpt.shipment_line_id=jm.shipment_line_id
281: and jpt.currency=jm.currency_code
282: AND jpt.tax_id=jm.tax_id)

Line 381: from jai_rcv_line_taxes

377: /*modified by vkaranam for bug#13618731
378: cursor get_rcv_tax_amt (cp_shipment_line_id in number ,cp_tax_id in number)
379: is
380: select tax_amount
381: from jai_rcv_line_taxes
382: where shipment_line_id=cp_shipment_line_id
383: and tax_id=cp_tax_id;
384: */
385: cursor get_rcv_tax_amt (cp_rcv_transaction_id in number ,cp_tax_id in number)

Line 388: from jai_rcv_line_taxes jt ,jai_rcv_transactions jrt

384: */
385: cursor get_rcv_tax_amt (cp_rcv_transaction_id in number ,cp_tax_id in number)
386: is
387: select jt.tax_amount
388: from jai_rcv_line_taxes jt ,jai_rcv_transactions jrt
389: where
390: jrt.shipment_header_id=jt.shipment_headeR_id
391: and jrt.shipment_line_id=jt.shipment_line_id
392: and jrt.transaction_id=cp_rcv_transaction_id