APPS.JAI_AP_IDA_TRIGGER_PKG dependencies on JAI_RCV_LINE_TAXES

Line 964: FROM JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b

960: AND trunc (p_inv_date) between start_date and end_date ; -- Modified by Jia for FP Bug#8656402, change sysdate to p_inv_date
961: /*START, by amandali for Bug#10430662*/
962: cursor c_receipt_wct_tax(p_shipment_line_id number) is
963: select a.tax_id
964: FROM JAI_RCV_LINE_TAXES a, JAI_CMN_TAXES_ALL b
965: where a.tax_id = b.tax_id
966: and a.shipment_line_id = p_shipment_line_id
967: and a.tax_type = 'TDS'
968: and b.section_type= 'WCT_SECTION';

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

1141: and jpt.currency=jm.currency_code
1142: AND jpt.tax_id=jm.tax_id)
1143: )
1144: OR
1145: (nvl(jct.adhoc_flag,'Q')='Y' and exists (select '1' from jai_rcv_line_taxes jpt
1146: where jpt.shipment_header_id=jm.shipment_header_id
1147: and jpt.shipment_line_id=jm.shipment_line_id
1148: and jpt.currency=jm.currency_code
1149: AND jpt.tax_id=jm.tax_id)

Line 1246: from jai_rcv_line_taxes

1242: /*modified by vkaranam for bug#13618731
1243: cursor get_rcv_tax_amt (cp_shipment_line_id in number ,cp_tax_id in number)
1244: is
1245: select tax_amount
1246: from jai_rcv_line_taxes
1247: where shipment_line_id=cp_shipment_line_id
1248: and tax_id=cp_tax_id;
1249: */
1250: cursor get_rcv_tax_amt (cp_rcv_transaction_id in number ,cp_tax_id in number)

Line 1253: from jai_rcv_line_taxes jt ,jai_rcv_transactions jrt

1249: */
1250: cursor get_rcv_tax_amt (cp_rcv_transaction_id in number ,cp_tax_id in number)
1251: is
1252: select jt.tax_amount
1253: from jai_rcv_line_taxes jt ,jai_rcv_transactions jrt
1254: where
1255: jrt.shipment_header_id=jt.shipment_headeR_id
1256: and jrt.shipment_line_id=jt.shipment_line_id
1257: and jrt.transaction_id=cp_rcv_transaction_id