2268: IS
2269: SELECT
2270: cenvat_claimed_ptg
2271: FROM
2272: jai_rcv_cenvat_claims
2273: WHERE transaction_id = pn_transaction_id;
2274:
2275:
2276:
2335: FETCH get_jai_transaction_cur
2336: INTO jai_transaction_rec;
2337: CLOSE get_jai_transaction_cur;
2338:
2339: --Get cenvat_claimed_ptg from jai_rcv_cenvat_claims for the current transaction_id
2340: OPEN get_rcv_cenvat_claim_cur;
2341: FETCH get_rcv_cenvat_claim_cur
2342: INTO
2343: ln_cenvat_claimed_ptg;