[Home] [Help]
172: FROM JAI_AR_TRX_INS_HDRS_T
173: WHERE customer_trx_id = v_customer_trx_id;
174: CURSOR fin_year_cur(p_org_id IN NUMBER) IS
175: SELECT MAX(a.fin_year)
176: FROM JAI_CMN_FIN_YEARS a
177: WHERE organization_id = p_org_id and fin_active_flag = 'Y';
178:
179: CURSOR matched_receipt_cur(p_customer_trx_line_id IN NUMBER) IS
180: SELECT a.receipt_id, a.quantity_applied, b.transaction_type,b.qty_to_adjust,