APPS.JA_JAINER1_XMLP_PKG dependencies on JAI_RCV_LINE_TAXES

Line 1767: JAI_RCV_LINE_TAXES JRTL

1763: SELECT
1764: 1
1765: FROM
1766: JAI_RCV_LINES JTL,
1767: JAI_RCV_LINE_TAXES JRTL
1768: WHERE JTL.TRANSACTION_ID = JIRP.RECEIPT_REF
1769: AND JTL.SHIPMENT_LINE_ID = JRTL.SHIPMENT_LINE_ID
1770: AND JRTL.TAX_TYPE IN ( 'ADDITIONAL_CVD' , 'CVD' ) ) ) ) );
1771: CURSOR CUR_CRDIT_INPUT_CUST IS

Line 1808: JAI_RCV_LINE_TAXES JRTL

1804: SELECT
1805: 1
1806: FROM
1807: JAI_RCV_LINES JTL,
1808: JAI_RCV_LINE_TAXES JRTL
1809: WHERE JTL.TRANSACTION_ID = JIRP.RECEIPT_REF
1810: AND JTL.SHIPMENT_LINE_ID = JRTL.SHIPMENT_LINE_ID
1811: AND JRTL.TAX_TYPE IN ( 'ADDITIONAL_CVD' , 'CVD' ) ) ) ) );
1812: CURSOR CUR_CRDIT_INPUT_MANF_ISO IS

Line 1846: JAI_RCV_LINE_TAXES JRTL

1842: SELECT
1843: 1
1844: FROM
1845: JAI_RCV_LINES JTL,
1846: JAI_RCV_LINE_TAXES JRTL
1847: WHERE JTL.TRANSACTION_ID = JIRP.RECEIPT_REF
1848: AND JTL.SHIPMENT_LINE_ID = JRTL.SHIPMENT_LINE_ID
1849: AND JRTL.TAX_TYPE IN ( 'ADDITIONAL_CVD' , 'CVD' ) ) ) ) );
1850: LN_CLOSED_INPUT_MANF NUMBER;

Line 1885: JAI_RCV_LINE_TAXES JRTL

1881: SELECT
1882: 1
1883: FROM
1884: JAI_RCV_LINES JTL,
1885: JAI_RCV_LINE_TAXES JRTL
1886: WHERE JTL.TRANSACTION_ID = JIRP.RECEIPT_REF
1887: AND JTL.SHIPMENT_LINE_ID = JRTL.SHIPMENT_LINE_ID
1888: AND JRTL.TAX_TYPE IN ( 'ADDITIONAL_CVD' , 'CVD' ) ) ) );
1889: BEGIN

Line 1954: JAI_RCV_LINE_TAXES JRTL

1950: SELECT
1951: 1
1952: FROM
1953: JAI_RCV_LINES JTL,
1954: JAI_RCV_LINE_TAXES JRTL
1955: WHERE JTL.TRANSACTION_ID = JIRP.RECEIPT_REF
1956: AND JTL.SHIPMENT_LINE_ID = JRTL.SHIPMENT_LINE_ID
1957: AND JRTL.TAX_TYPE IN ( 'ADDITIONAL_CVD' , 'CVD' ) ) ) ) );
1958: CURSOR CUR_CRDIT_INPUT_STG_ISO IS

Line 1992: JAI_RCV_LINE_TAXES JRTL

1988: SELECT
1989: 1
1990: FROM
1991: JAI_RCV_LINES JTL,
1992: JAI_RCV_LINE_TAXES JRTL
1993: WHERE JTL.TRANSACTION_ID = JIRP.RECEIPT_REF
1994: AND JTL.SHIPMENT_LINE_ID = JRTL.SHIPMENT_LINE_ID
1995: AND JRTL.TAX_TYPE IN ( 'ADDITIONAL_CVD' , 'CVD' ) ) ) ) );
1996: LN_CLOSED_INPUT_STG NUMBER;

Line 2462: JAI_RCV_LINE_TAXES JRTL

2458: SELECT
2459: 1
2460: FROM
2461: JAI_RCV_LINES JTL,
2462: JAI_RCV_LINE_TAXES JRTL
2463: WHERE JTL.TRANSACTION_ID = JIRP.RECEIPT_REF
2464: AND JTL.SHIPMENT_LINE_ID = JRTL.SHIPMENT_LINE_ID
2465: AND JRTL.TAX_TYPE IN ( 'ADDITIONAL_CVD' , 'CVD' ) ) ) );
2466: BEGIN