APPS.OE_ORDER_PURGE_PVT dependencies on OE_PAYMENTS

Line 3612: From oe_payments

3608: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3609:
3610: Cursor c_header_pmts IS
3611: Select payment_number
3612: From oe_payments
3613: Where header_id = p_header_id
3614: and line_id is null
3615: FOR UPDATE NOWAIT;
3616:

Line 3625: Delete from oe_payments

3621:
3622: FETCH c_header_pmts into l_payment_number;
3623: EXIT WHEN c_header_pmts%NOTFOUND or c_header_pmts%NOTFOUND is NULL;
3624:
3625: Delete from oe_payments
3626: Where header_id = p_header_id
3627: and nvl(payment_number,0) = nvl(l_payment_number,0);
3628:
3629: END LOOP;

Line 3662: from oe_payments

3658: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3659:
3660: cursor c_lock_pmts is
3661: select payment_number
3662: from oe_payments
3663: where line_id = p_line_id
3664: and header_id = p_header_id
3665: FOR UPDATE NOWAIT;
3666:

Line 3675: Delete from oe_payments

3671:
3672: FETCH c_lock_pmts into l_payment_number;
3673: EXIT WHEN c_lock_pmts%NOTFOUND or c_lock_pmts%NOTFOUND is NULL;
3674:
3675: Delete from oe_payments
3676: Where line_id = p_line_id
3677: and nvl(payment_number,0) = nvl(l_payment_number,0);
3678:
3679: END LOOP;