APPS.OKL_SALES_QUOTE_QA_PVT dependencies on OKL_FEES_B

Line 1800: from okl_fees_b ofv

1796: select ofv.id,
1797: ofv.rate_card_id,
1798: ofv.rate_template_id,
1799: 'QUOTED_FEES' oty_code
1800: from okl_fees_b ofv
1801: where ofv.parent_object_code='LEASEQUOTE'
1802: AND ofv.parent_object_id=p_quote_id
1803: AND ofv.fee_type IN ('FINANCED','ROLLOVER')
1804: UNION

Line 3049: okl_fees_b ofv

3045: --cursor can fetch multiple Records
3046: cursor c_lq_asset_line(p_parent_object_id NUMBER,p_fee_id NUMBER) IS
3047: select olr.*
3048: from okl_line_relationships_b olr,
3049: okl_fees_b ofv
3050: where ofv.FEE_TYPE='CAPITALIZED'
3051: AND olr.related_line_id = p_fee_id
3052: AND olr.related_line_id = ofv.id -- Added by rravikir for Bug 4736523
3053: AND olr.related_line_type = 'CAPITALIZED';

Line 3270: from okl_fees_b ofv,

3266: 'QUOTED_FEE' oty_code,
3267: ofv.target_arrears,
3268: ofv.target_amount,
3269: STYT.NAME NAME
3270: from okl_fees_b ofv,
3271: OKL_STRM_TYPE_B STY,
3272: OKL_STRM_TYPE_TL STYT
3273: where ofv.parent_object_code='LEASEQUOTE'
3274: AND ofv.parent_object_id=p_quote_id

Line 3302: from okl_fees_b ofv

3298: ofv.rate_template_id,
3299: ofv.structured_pricing,
3300: ofv.lease_rate_factor,
3301: 'QUOTED_FEE' oty_code
3302: from okl_fees_b ofv
3303: where ofv.parent_object_code='LEASEQUOTE'
3304: AND ofv.parent_object_id=p_quote_id
3305: AND ofv.fee_type IN ('FINANCED','ROLLOVER')
3306: UNION