APPS.OZF_CHARGEBACK_PVT dependencies on OZF_RESALE_BATCHES_ALL

Line 162: FROM ozf_resale_batches_all

158: last_updated_by,
159: currency_code,
160: partner_claim_number,
161: org_id
162: FROM ozf_resale_batches_all
163: WHERE resale_batch_id = p_id;
164:
165: CURSOR open_line_count_csr (p_id IN NUMBER) IS
166: SELECT count(1)

Line 289: ozf_resale_batches_all orba

285: CURSOR sysparam_accrual_flag_csr (p_resale_batch_id IN NUMBER)
286: IS
287: SELECT NVL(ospa.ship_debit_accrual_flag, 'F')
288: FROM ozf_sys_parameters_all ospa,
289: ozf_resale_batches_all orba
290: WHERE ospa.org_id = orba.org_id
291: AND orba.resale_batch_id = p_resale_batch_id;
292:
293: -- For Bug#8867381

Line 420: UPDATE ozf_resale_batches_all

416: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
418: END IF;
419:
420: UPDATE ozf_resale_batches_all
421: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
422: WHERE resale_batch_id = p_resale_batch_id;
423:
424: RAISE error_no_rollback;