DBA Data[Home] [Help]

APPS.JAI_CMN_ST_FORMS_PKG dependencies on JAI_AR_TRX_LINES

Line 1674: FROM JAI_AR_TRX_LINES trx_lines

1670: a.invoice_id = trx.customer_trx_id
1671: ) AND
1672: EXISTS
1673: (SELECT 1
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 ,

Line 1717: from JAI_AR_TRX_LINES

1713: JAI_CMN_TAXES_ALL jtc
1714: where link_to_cust_Trx_line_id in
1715: (
1716: select customer_Trx_line_id
1717: from JAI_AR_TRX_LINES
1718: where customer_trx_id = p_invoice_id
1719: )
1720: and jtc.tax_id = jtxn.tax_id
1721: and jtc.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*/

Line 1814: from JAI_AR_TRX_LINES

1810: and tax_id = p_tax_id;
1811:
1812: cursor c_get_line_amount
1813: is select line_amount
1814: from JAI_AR_TRX_LINES
1815: where customer_trx_line_id = p_link_to_line_id;
1816:
1817: v_prec_rec c_get_precedences%rowtype;
1818: