eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LEASE_QUOTE_FEE_PVT dependencies on OKL_LEASE_QUOTES_B

Line 16: from okl_lease_quotes_b

12: lv_target_pricing_type VARCHAR2(15);
13: BEGIN
14: select pricing_method
15: into lv_source_pricing_type
16: from okl_lease_quotes_b
17: where id = p_source_quote_id;
18:
19: select pricing_method
20: into lv_target_pricing_type

Line 21: from okl_lease_quotes_b

17: where id = p_source_quote_id;
18:
19: select pricing_method
20: into lv_target_pricing_type
21: from okl_lease_quotes_b
22: where id = p_target_quote_id;
23:
24: IF (lv_source_pricing_type = lv_target_pricing_type) THEN
25: RETURN 'Y';

Line 56: FROM okl_lease_quotes_b

52: l_expense_level_tbl := p_expense_level_tbl;
53:
54: SELECT expected_start_date
55: INTO l_k_effective_from
56: FROM okl_lease_quotes_b
57: WHERE id = l_fee_rec.parent_object_id;
58:
59: --bug 4737394 start
60: IF l_fee_rec.fee_type = 'INCOME' THEN

Line 177: FROM okl_lease_quotes_b

173: SELECT expected_start_date,
174: ADD_MONTHS(expected_start_date, term)-1
175: INTO l_quote_start_date,
176: l_quote_end_date
177: FROM okl_lease_quotes_b
178: WHERE id = p_fee_rec.parent_object_id;
179:
180: IF p_fee_rec.fee_type IN ('EXPENSE', 'MISCELLANEOUS') THEN
181:

Line 580: lv_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;

576: l_compare_amt NUMBER;
577: l_diff NUMBER;
578: l_adj_rec BINARY_INTEGER;
579: lx_return_status VARCHAR2(1);
580: lv_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;
581:
582: CURSOR c_get_parent_object_code IS
583: SELECT parent_object_code
584: FROM okl_lease_quotes_b

Line 584: FROM okl_lease_quotes_b

580: lv_pricing_method OKL_LEASE_QUOTES_B.PRICING_METHOD%TYPE;
581:
582: CURSOR c_get_parent_object_code IS
583: SELECT parent_object_code
584: FROM okl_lease_quotes_b
585: WHERE id = p_quote_id;
586: BEGIN
587:
588: l_link_asset_tbl := p_link_asset_tbl;

Line 592: FROM OKL_LEASE_QUOTES_B

588: l_link_asset_tbl := p_link_asset_tbl;
589:
590: SELECT PRICING_METHOD
591: INTO lv_pricing_method
592: FROM OKL_LEASE_QUOTES_B
593: WHERE ID = p_quote_id;
594:
595: -- Fee Asset amount will be null in case of 'Solve for Financed Amount' pricing
596: -- method .. the values will be populated after the Pricing call is made

Line 619: okl_lease_quotes_b lsq

615: IF (lv_parent_object_code = 'LEASEOPP') THEN
616: SELECT currency_code
617: INTO l_currency_code
618: FROM okl_lease_opportunities_b lop,
619: okl_lease_quotes_b lsq
620: WHERE lsq.parent_object_code = lv_parent_object_code
621: AND lsq.parent_object_id = lop.id
622: AND lsq.id = p_quote_id;
623: ELSIF (lv_parent_object_code = 'LEASEAPP') THEN

Line 627: okl_lease_quotes_b lsq

623: ELSIF (lv_parent_object_code = 'LEASEAPP') THEN
624: SELECT currency_code
625: INTO l_currency_code
626: FROM okl_lease_applications_b lap,
627: okl_lease_quotes_b lsq
628: WHERE lsq.parent_object_code = lv_parent_object_code
629: AND lsq.parent_object_id = lap.id
630: AND lsq.id = p_quote_id;
631: END IF;

Line 1633: FROM okl_lease_quotes_b where ID = l_fee_rec.parent_object_id;

1629: END IF;
1630:
1631: /*
1632: SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code
1633: FROM okl_lease_quotes_b where ID = l_fee_rec.parent_object_id;
1634:
1635: OKL_LEASE_QUOTE_PRICING_PVT.handle_parent_object_status(
1636: p_api_version => G_API_VERSION
1637: ,p_init_msg_list => G_FALSE

Line 1880: FROM okl_lease_quotes_b where ID = l_fee_rec.parent_object_id;

1876: END IF;
1877:
1878: /*
1879: SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code
1880: FROM okl_lease_quotes_b where ID = l_fee_rec.parent_object_id;
1881:
1882: OKL_LEASE_QUOTE_PRICING_PVT.handle_parent_object_status(
1883: p_api_version => G_API_VERSION
1884: ,p_init_msg_list => G_FALSE

Line 2148: FROM okl_lease_quotes_b where ID = l_fee_rec.parent_object_id;

2144: END IF;
2145:
2146: /*
2147: SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code
2148: FROM okl_lease_quotes_b where ID = l_fee_rec.parent_object_id;
2149:
2150: OKL_LEASE_QUOTE_PRICING_PVT.handle_parent_object_status(
2151: p_api_version => G_API_VERSION
2152: ,p_init_msg_list => G_FALSE

Line 2532: l_parent_object_code okl_lease_quotes_b.parent_object_code%TYPE;

2528: ld_src_start_date DATE;
2529: ld_tgt_start_date DATE;
2530: ln_src_pdt_id NUMBER;
2531: ln_tgt_pdt_id NUMBER;
2532: l_parent_object_code okl_lease_quotes_b.parent_object_code%TYPE;
2533: ln_src_eot_id NUMBER;
2534: ln_tgt_eot_id NUMBER;
2535:
2536: BEGIN

Line 2569: okl_lease_quotes_b

2565: parent_object_code,
2566: end_of_term_option_id
2567: INTO ld_tgt_start_date, ln_tgt_pdt_id,l_parent_object_code, ln_tgt_eot_id
2568: FROM
2569: okl_lease_quotes_b
2570: WHERE
2571: id = p_target_quote_id;
2572: --
2573: IF (lb_config_fee) THEN

Line 2621: okl_lease_quotes_b quote

2617: quote.end_of_term_option_id
2618: INTO ld_src_start_date, ln_src_pdt_id, ln_src_eot_id
2619: FROM
2620: okl_fees_b fee,
2621: okl_lease_quotes_b quote
2622: WHERE
2623: fee.id = p_source_fee_id
2624: AND fee.parent_object_id = quote.id
2625: AND fee.parent_object_code = 'LEASEQUOTE';

Line 2819: FROM okl_lease_quotes_b qte,

2815:
2816: /*
2817: SELECT qte.parent_object_id,qte.parent_object_code
2818: INTO l_p_id,l_p_code
2819: FROM okl_lease_quotes_b qte,
2820: okl_fees_b fee
2821: WHERE fee.parent_object_id = qte.id
2822: AND fee.parent_object_code= 'LEASEQUOTE'
2823: AND fee.ID = p_fee_id;