APPS.JAI_CMN_ST_FORMS_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 1678: FROM JAI_AR_TRX_TAX_LINES tax_lines ,

1674: FROM JAI_AR_TRX_LINES trx_lines
1675: WHERE customer_trx_id = trx.customer_trx_id AND
1676: EXISTS
1677: (SELECT 1
1678: FROM JAI_AR_TRX_TAX_LINES tax_lines ,
1679: JAI_CMN_TAXES_ALL jtc
1680: WHERE link_to_cust_trx_line_id = trx_lines.customer_trx_line_id AND
1681: tax_type IN ( jai_constants.tax_type_sales, jai_constants.tax_type_cst) --('Sales Tax','CST') /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
1682: AND jtc.tax_id = tax_lines.tax_id AND

Line 1712: from JAI_AR_TRX_TAX_LINES jtxn ,

1708: jtxn.TAX_AMOUNT ,
1709: jtxn.INVOICE_CLASS ,
1710: jtxn.base_tax_amount ,
1711: jtc.stform_type
1712: from JAI_AR_TRX_TAX_LINES jtxn ,
1713: JAI_CMN_TAXES_ALL jtc
1714: where link_to_cust_Trx_line_id in
1715: (
1716: select customer_Trx_line_id

Line 1766: FROM JAI_AR_TRX_TAX_LINES

1762: */
1763: function get_base_tax_amount(p_Link_to_line_id number , p_tax_id number) return number is
1764: cursor c_tax_amount is
1765: SELECT SUM(tax_amount)
1766: FROM JAI_AR_TRX_TAX_LINES
1767: WHERE link_to_cust_trx_line_id = p_Link_to_line_id
1768: AND tax_line_no IN
1769: (
1770: SELECT precedence_1

Line 1771: FROM JAI_AR_TRX_TAX_LINES

1767: WHERE link_to_cust_trx_line_id = p_Link_to_line_id
1768: AND tax_line_no IN
1769: (
1770: SELECT precedence_1
1771: FROM JAI_AR_TRX_TAX_LINES
1772: WHERE link_to_cust_trx_line_id = p_Link_to_line_id
1773: and precedence_1 is not null
1774: AND tax_id = p_tax_id
1775: UNION

Line 1777: FROM JAI_AR_TRX_TAX_LINES

1773: and precedence_1 is not null
1774: AND tax_id = p_tax_id
1775: UNION
1776: SELECT precedence_2
1777: FROM JAI_AR_TRX_TAX_LINES
1778: WHERE link_to_cust_trx_line_id = p_Link_to_line_id
1779: AND tax_id = p_tax_id
1780: and precedence_1 is not null
1781: UNION

Line 1783: FROM JAI_AR_TRX_TAX_LINES

1779: AND tax_id = p_tax_id
1780: and precedence_1 is not null
1781: UNION
1782: SELECT precedence_3
1783: FROM JAI_AR_TRX_TAX_LINES
1784: WHERE link_to_cust_trx_line_id = p_Link_to_line_id
1785: AND tax_id = p_tax_id
1786: and precedence_1 is not null
1787: UNION

Line 1789: FROM JAI_AR_TRX_TAX_LINES

1785: AND tax_id = p_tax_id
1786: and precedence_1 is not null
1787: UNION
1788: SELECT precedence_4
1789: FROM JAI_AR_TRX_TAX_LINES
1790: WHERE link_to_cust_trx_line_id = p_Link_to_line_id
1791: and precedence_1 is not null
1792: AND tax_id = p_tax_id
1793: UNION

Line 1795: FROM JAI_AR_TRX_TAX_LINES

1791: and precedence_1 is not null
1792: AND tax_id = p_tax_id
1793: UNION
1794: SELECT precedence_5
1795: FROM JAI_AR_TRX_TAX_LINES
1796: WHERE link_to_cust_trx_line_id = p_Link_to_line_id
1797: and precedence_1 is not null
1798: AND tax_id = p_tax_id
1799: );

Line 1808: from JAI_AR_TRX_TAX_LINES

1804: precedence_2,
1805: precedence_3,
1806: precedence_4,
1807: precedence_5
1808: from JAI_AR_TRX_TAX_LINES
1809: where link_to_cust_trx_line_id = p_Link_to_line_id
1810: and tax_id = p_tax_id;
1811:
1812: cursor c_get_line_amount

Line 1989: -- JAI_AR_TRX_TAX_LINES

1985: v_order_line_id := tax_rec.link_to_cust_trx_line_id;
1986: -- based on input from NPAI
1987: -- either from Autoinvoiced invoice or a manual ar invoice ,
1988: -- we need to populate customer trx line id of the line to which the Tax is attached from
1989: -- JAI_AR_TRX_TAX_LINES
1990:
1991: if tax_rec.tax_rate > 0 and tax_rec.base_tax_amount is not null then
1992: v_base_tax_amt := (tax_rec.tax_amount * 100) / tax_rec.tax_rate;
1993: end if;