DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_WORKFLOW_PVT dependencies on OKL_LEASE_QUOTES_B

Line 39: SELECT parent_object_code, parent_object_id FROM okl_lease_quotes_b

35: SUBTYPE lapv_rec_type IS OKL_LAP_PVT.LAPV_REC_TYPE;
36:
37: -- curosr to fetch the parent record of
38: CURSOR get_parent_object(quote_id IN NUMBER) IS
39: SELECT parent_object_code, parent_object_id FROM okl_lease_quotes_b
40: WHERE id=quote_id;
41: -- viselvar end
42:
43: ------------------------------------------------------------------------------

Line 228: FROM okl_lease_quotes_b

224: -- Bug 4713798 - Added cursor
225: CURSOR c_obj
226: IS
227: SELECT object_version_number
228: FROM okl_lease_quotes_b
229: WHERE id = p_quote_id;
230:
231: BEGIN
232:

Line 768: FROM okl_lease_quotes_b

764:
765: CURSOR c_fetch_quote_number(p_quote_id OKL_LEASE_QUOTES_V.ID%TYPE)
766: IS
767: SELECT reference_number, valid_from, valid_to, parent_object_code, parent_object_id
768: FROM okl_lease_quotes_b
769: WHERE id = p_quote_id;
770:
771: -- Commented by Venkatho as part of Bug : 15933691
772: /* CURSOR fnd_user_csr IS