APPS.JAI_AR_TRXS_PKG dependencies on JAI_CMN_MATCH_RECEIPTS

Line 182: FROM JAI_CMN_MATCH_RECEIPTS a, JAI_CMN_RG_23D_TRXS b

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,
181: b.rate_per_unit,b.excise_duty_rate
182: FROM JAI_CMN_MATCH_RECEIPTS a, JAI_CMN_RG_23D_TRXS b
183: WHERE a.ref_line_id = p_customer_trx_line_id
184: AND a.receipt_id = b.register_id
185: AND a.quantity_applied > 0 ;
186: CURSOR tax_rate_cur(p_customer_trx_line_id IN NUMBER, p_receipt_id IN NUMBER)

Line 229: lv_ship_status JAI_CMN_MATCH_RECEIPTS.ship_status%type ;

225:
226: VSQLERRM varchar2(250);
227: vsqlstmt varchar2(20);
228:
229: lv_ship_status JAI_CMN_MATCH_RECEIPTS.ship_status%type ;
230:
231:
232: CURSOR cur_get_trx_cess_amt (cp_trx_line_id in number)
233: IS

Line 749: UPDATE JAI_CMN_MATCH_RECEIPTS

745: );
746:
747: lv_ship_status := 'CLOSED' ;
748:
749: UPDATE JAI_CMN_MATCH_RECEIPTS
750: set ship_status = lv_ship_status --'CLOSED'
751: where ref_line_id = l_rec.customer_trx_line_id;
752: END LOOP;
753: END IF;