APPS.OKL_LEASE_QUOTE_SERVICE_PVT dependencies on OKL_LEASE_QUOTES_B

Line 58: FROM okl_lease_quotes_b

54: BEGIN
55:
56: SELECT parent_object_code
57: INTO l_parent_object_code
58: FROM okl_lease_quotes_b
59: WHERE id = p_parent_object_id;
60:
61: IF (l_parent_object_code = 'LEASEOPP') THEN
62: SELECT currency_code

Line 65: okl_lease_quotes_b lsq

61: IF (l_parent_object_code = 'LEASEOPP') THEN
62: SELECT currency_code
63: INTO x_currency_code
64: FROM okl_lease_opportunities_b lop,
65: okl_lease_quotes_b lsq
66: WHERE lsq.parent_object_code = l_parent_object_code
67: AND lsq.parent_object_id = lop.id
68: AND lsq.id = p_parent_object_id;
69: ELSIF (l_parent_object_code = 'LEASEAPP') THEN

Line 73: okl_lease_quotes_b lsq

69: ELSIF (l_parent_object_code = 'LEASEAPP') THEN
70: SELECT currency_code
71: INTO x_currency_code
72: FROM okl_lease_applications_b lap,
73: okl_lease_quotes_b lsq
74: WHERE lsq.parent_object_code = l_parent_object_code
75: AND lsq.parent_object_id = lap.id
76: AND lsq.id = p_parent_object_id;
77: END IF;

Line 299: lv_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;

295: l_compare_amt NUMBER;
296: l_diff NUMBER;
297: l_adj_rec BINARY_INTEGER;
298: lx_return_status VARCHAR2(1);
299: lv_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;
300:
301: BEGIN
302:
303: l_link_asset_tbl := p_link_asset_tbl;

Line 308: FROM OKL_LEASE_QUOTES_B

304: l_line_amount := p_service_amount;
305:
306: SELECT PRICING_METHOD
307: INTO lv_pricing_method
308: FROM OKL_LEASE_QUOTES_B
309: WHERE ID = p_quote_id;
310:
311: -- Service Asset amount will be null in case of 'Solve for Financed Amount' pricing
312: -- method .. the values will be populated after the Pricing call is made

Line 2160: okl_lease_quotes_b quote

2156: quote.end_of_term_option_id
2157: INTO ld_src_start_date, ln_src_pdt_id, ln_src_eot_id
2158: FROM
2159: okl_services_b srv,
2160: okl_lease_quotes_b quote
2161: WHERE
2162: srv.id = p_source_service_id
2163: AND srv.parent_object_id = quote.id
2164: AND srv.parent_object_code = 'LEASEQUOTE';

Line 2171: okl_lease_quotes_b

2167: product_id,
2168: end_of_term_option_id
2169: INTO ld_tgt_start_date, ln_tgt_pdt_id, ln_tgt_eot_id
2170: FROM
2171: okl_lease_quotes_b
2172: WHERE
2173: id = p_target_quote_id;
2174:
2175: IF ((ld_src_start_date <> ld_tgt_start_date) OR (ln_src_pdt_id <> ln_tgt_pdt_id)) THEN