DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_FEE_PVT dependencies on OKL_FEES_B

Line 2308: FROM OKL_FEES_B

2304: END IF;
2305:
2306: SELECT PARENT_OBJECT_ID
2307: INTO ln_target_quote_id
2308: FROM OKL_FEES_B
2309: WHERE ID = p_target_fee_id;
2310:
2311: -- Set the original asset id for the records
2312: IF (l_lrship_tbl.COUNT > 0) THEN

Line 2583: okl_fees_b fee,

2579: quote.product_id,
2580: quote.end_of_term_option_id
2581: INTO ld_src_start_date, ln_src_pdt_id, ln_src_eot_id
2582: FROM
2583: okl_fees_b fee,
2584: okl_lease_quotes_b quote
2585: WHERE
2586: fee.id = p_source_fee_id
2587: AND fee.parent_object_id = quote.id

Line 2718: SELECT fee_type INTO l_fee_type FROM okl_fees_b WHERE id = p_fee_id;

2714: IF p_init_msg_list = G_TRUE THEN
2715: FND_MSG_PUB.initialize;
2716: END IF;
2717:
2718: SELECT fee_type INTO l_fee_type FROM okl_fees_b WHERE id = p_fee_id;
2719:
2720: i := 0;
2721: FOR l_assoc_assets IN c_fee_sublines (p_fee_type => l_fee_type) LOOP
2722: l_assoc_asset_tbl(i).id := l_assoc_assets.id;

Line 2783: okl_fees_b fee

2779: /*
2780: SELECT qte.parent_object_id,qte.parent_object_code
2781: INTO l_p_id,l_p_code
2782: FROM okl_lease_quotes_b qte,
2783: okl_fees_b fee
2784: WHERE fee.parent_object_id = qte.id
2785: AND fee.parent_object_code= 'LEASEQUOTE'
2786: AND fee.ID = p_fee_id;
2787: OKL_LEASE_QUOTE_PRICING_PVT.handle_parent_object_status(