APPS.JAI_CMN_ST_FORMS_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 1825: FROM JAI_AR_TRX_TAX_LINES tax_lines ,

1821: FROM JAI_AR_TRX_LINES trx_lines
1822: WHERE customer_trx_id = trx.customer_trx_id AND
1823: EXISTS
1824: (SELECT 1
1825: FROM JAI_AR_TRX_TAX_LINES tax_lines ,
1826: JAI_CMN_TAXES_ALL jtc
1827: WHERE link_to_cust_trx_line_id = trx_lines.customer_trx_line_id AND
1828: 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*/
1829: AND jtc.tax_id = tax_lines.tax_id AND

Line 1859: from JAI_AR_TRX_TAX_LINES jtxn ,

1855: jtxn.TAX_AMOUNT ,
1856: jtxn.INVOICE_CLASS ,
1857: jtxn.base_tax_amount ,
1858: jtc.stform_type
1859: from JAI_AR_TRX_TAX_LINES jtxn ,
1860: JAI_CMN_TAXES_ALL jtc
1861: where link_to_cust_Trx_line_id in
1862: (
1863: select customer_Trx_line_id

Line 1913: FROM JAI_AR_TRX_TAX_LINES

1909: */
1910: function get_base_tax_amount(p_Link_to_line_id number , p_tax_id number) return number is
1911: cursor c_tax_amount is
1912: SELECT SUM(tax_amount)
1913: FROM JAI_AR_TRX_TAX_LINES
1914: WHERE link_to_cust_trx_line_id = p_Link_to_line_id
1915: AND tax_line_no IN
1916: (
1917: SELECT precedence_1

Line 1918: FROM JAI_AR_TRX_TAX_LINES

1914: WHERE link_to_cust_trx_line_id = p_Link_to_line_id
1915: AND tax_line_no IN
1916: (
1917: SELECT precedence_1
1918: FROM JAI_AR_TRX_TAX_LINES
1919: WHERE link_to_cust_trx_line_id = p_Link_to_line_id
1920: and precedence_1 is not null
1921: AND tax_id = p_tax_id
1922: UNION

Line 1924: FROM JAI_AR_TRX_TAX_LINES

1920: and precedence_1 is not null
1921: AND tax_id = p_tax_id
1922: UNION
1923: SELECT precedence_2
1924: FROM JAI_AR_TRX_TAX_LINES
1925: WHERE link_to_cust_trx_line_id = p_Link_to_line_id
1926: AND tax_id = p_tax_id
1927: and precedence_1 is not null
1928: UNION

Line 1930: FROM JAI_AR_TRX_TAX_LINES

1926: AND tax_id = p_tax_id
1927: and precedence_1 is not null
1928: UNION
1929: SELECT precedence_3
1930: FROM JAI_AR_TRX_TAX_LINES
1931: WHERE link_to_cust_trx_line_id = p_Link_to_line_id
1932: AND tax_id = p_tax_id
1933: and precedence_1 is not null
1934: UNION

Line 1936: FROM JAI_AR_TRX_TAX_LINES

1932: AND tax_id = p_tax_id
1933: and precedence_1 is not null
1934: UNION
1935: SELECT precedence_4
1936: FROM JAI_AR_TRX_TAX_LINES
1937: WHERE link_to_cust_trx_line_id = p_Link_to_line_id
1938: and precedence_1 is not null
1939: AND tax_id = p_tax_id
1940: UNION

Line 1942: FROM JAI_AR_TRX_TAX_LINES

1938: and precedence_1 is not null
1939: AND tax_id = p_tax_id
1940: UNION
1941: SELECT precedence_5
1942: FROM JAI_AR_TRX_TAX_LINES
1943: WHERE link_to_cust_trx_line_id = p_Link_to_line_id
1944: and precedence_1 is not null
1945: AND tax_id = p_tax_id
1946: );

Line 1955: from JAI_AR_TRX_TAX_LINES

1951: precedence_2,
1952: precedence_3,
1953: precedence_4,
1954: precedence_5
1955: from JAI_AR_TRX_TAX_LINES
1956: where link_to_cust_trx_line_id = p_Link_to_line_id
1957: and tax_id = p_tax_id;
1958:
1959: cursor c_get_line_amount

Line 2136: -- JAI_AR_TRX_TAX_LINES

2132: v_order_line_id := tax_rec.link_to_cust_trx_line_id;
2133: -- based on input from NPAI
2134: -- either from Autoinvoiced invoice or a manual ar invoice ,
2135: -- we need to populate customer trx line id of the line to which the Tax is attached from
2136: -- JAI_AR_TRX_TAX_LINES
2137:
2138: if tax_rec.tax_rate > 0 and tax_rec.base_tax_amount is not null then
2139: v_base_tax_amt := (tax_rec.tax_amount * 100) / tax_rec.tax_rate;
2140: end if;