[Home] [Help]
239: THEN
240:
241: SELECT org_id
242: INTO l_org_id
243: FROM RA_CUSTOMER_TRX_ALL
244: WHERE customer_trx_id = p_unique_id;
245:
246: ELSIF p_column_name = 'CASH_RECEIPT_ID'
247: THEN
274: THEN
275:
276: SELECT org_id
277: INTO l_org_id
278: FROM ra_customer_trx_all
279: WHERE request_id = p_unique_id
280: AND rownum = 1;
281:
282: ELSIF p_trx_type = 'RECEIPTS'