[Home] [Help]
67: a.customer_trx_line_id line_id ,
68: a.tax_line_no tax_line_no -- added by sriram - 10/4/2003 - bug # 2769439
69: FROM
70: JAI_AR_TRX_TAX_LINES a ,
71: JAI_CMN_TAXES_ALL b
72: WHERE
73: link_to_cust_trx_line_id = v_customer_trx_line_id AND
74: a.tax_id = b.tax_id
75: AND NVL(b.inclusive_tax_flag,'N') = 'N' --Added by Jia Li for Tax inclusive Computations on 2007/11/22, TD11
113:
114:
115: CURSOR TAX_CCID_CUR(p_tax_id IN NUMBER) IS
116: SELECT tax_account_id
117: FROM JAI_CMN_TAXES_ALL B
118: WHERE B.tax_id = p_tax_id ;
119:
120: CURSOR CREATED_FROM_CUR IS
121: SELECT created_from, interface_header_attribute1,interface_header_attribute2
174: */
175: -------------------------------------------------------------------------
176: -- Deleted by Jia Li for Tax inclusive Computations on 2007/11/22 End
177:
178: CURSOR cur_chk_rgm ( cp_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE )
179: IS
180: SELECT
181: regime_id ,
182: regime_code
894: a.customer_trx_line_id line_id ,
895: a.tax_line_no tax_line_no
896: FROM
897: JAI_AR_TRX_TAX_LINES a ,
898: JAI_CMN_TAXES_ALL b
899: WHERE
900: link_to_cust_trx_line_id = pr_old.customer_trx_line_id and
901: a.tax_id = b.tax_id
902: AND NVL(b.inclusive_tax_flag,'N') = 'N' --Added by Jia Li for Tax inclusive Computations on 2007/11/22
946: /* Added by Ramananda for bug#4468353 , end */
947:
948: CURSOR TAX_CCID_CUR(p_tax_id IN NUMBER) IS
949: SELECT tax_account_id
950: FROM JAI_CMN_TAXES_ALL B
951: WHERE B.tax_id = p_tax_id ;
952:
953: CURSOR GL_DATE_CUR IS
954: SELECT gl_date
983: /* Bug 5243532. Added by Lakshmi Gopalsami
984: * Removed cursor set_of_books_cur and c_opr_set_of_books_id
985: * and implemented caching logic.
986: */
987: CURSOR cur_chk_rgm ( cp_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE )
988: IS
989: SELECT
990: regime_id ,
991: regime_code