APPS.JAI_AR_TRXS_PKG dependencies on JAI_AR_TRX_LINES

Line 88: lv_excise_invoice_no jai_ar_trx_lines.excise_invoice_no%TYPE;

84: v_opt_unit Number;
85: v_bill_to_customer_id Number;
86: v_bill_to_site_use_id Number;
87:
88: lv_excise_invoice_no jai_ar_trx_lines.excise_invoice_no%TYPE;
89: req_id NUMBER;
90: result BOOLEAN;
91:
92: --added by Zhiwei for bug#14640257 begin

Line 130: FROM JAI_AR_TRX_LINES

126: SELECT customer_trx_line_id line_id, payment_register, inventory_item_id,
127: quantity quantity_invoiced,unit_selling_price,unit_code,
128: excise_invoice_no, excise_invoice_date, assessable_value,
129: customer_trx_line_id, excise_exempt_type
130: FROM JAI_AR_TRX_LINES
131: WHERE customer_trx_id = v_customer_trx_id;
132: CURSOR REG_BALANCE_CUR(p_org_id IN Number,
133: p_loc_id IN Number) IS
134: SELECT nvl(rg23a_balance,0) rg23a_balance ,nvl(rg23c_balance,0) rg23c_balance,

Line 237: jai_ar_trx_lines jrctl ,

233: IS
234: SELECT
235: sum(jrcttl.func_tax_amount) cess_amount
236: FROM
237: jai_ar_trx_lines jrctl ,
238: jai_ar_trx_tax_lines jrcttl ,
239: jai_cmn_taxes_all jtc
240: WHERE
241: jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id AND

Line 253: jai_ar_trx_lines jrctl,

249: IS
250: SELECT
251: sum(jrcttl.func_tax_amount) sh_cess_amount
252: FROM
253: jai_ar_trx_lines jrctl,
254: jai_ar_trx_tax_lines jrcttl,
255: jai_cmn_taxes_all jtc
256: WHERE
257: jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id AND