APPS.OKL_LEASE_QUOTE_SERVICE_PVT dependencies on OKL_SERVICES_B

Line 872: OKL_SERVICES_B SRV

868: --05-Nov-2009 sechawla 9004863 : Modified the cursor to get asset id based on the new lease quote
869: CURSOR c_get_new_asset_id (p_source_asset_id IN NUMBER) IS
870: SELECT AST.id
871: FROM OKL_ASSETS_B AST,
872: OKL_SERVICES_B SRV
873: WHERE SRV.PARENT_OBJECT_CODE = 'LEASEQUOTE'
874: AND SRV.PARENT_OBJECT_ID = AST.PARENT_OBJECT_ID
875: AND SRV.ID = p_target_service_id
876: AND AST.ORIG_ASSET_ID = p_source_asset_id;

Line 1659: AND CFO.SOURCE_TABLE = 'OKL_SERVICES_B'

1655: OKL_CASH_FLOWS CFL,
1656: OKL_CASH_FLOW_LEVELS LVL
1657: WHERE CFO.SOURCE_ID = p_service_id
1658: AND CFO.OTY_CODE = 'QUOTED_SERVICE'
1659: AND CFO.SOURCE_TABLE = 'OKL_SERVICES_B'
1660: AND CFL.CFT_CODE = 'OUTFLOW_SCHEDULE'
1661: AND CFL.CFO_ID = CFO.ID
1662: AND LVL.CAF_ID = CFL.ID;
1663:

Line 2159: okl_services_b srv,

2155: quote.product_id,
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