APPS.OKL_LEASE_QUOTE_PRICING_PVT dependencies on OKL_FEES_B

Line 1152: FROM OKL_FEES_B

1148: AND parent_object_code = 'LEASEQUOTE';
1149:
1150: CURSOR quote_fees_csr(lc_quote_id IN NUMBER) IS
1151: SELECT ID
1152: FROM OKL_FEES_B
1153: WHERE parent_object_id = lc_quote_id
1154: AND parent_object_code = 'LEASEQUOTE'
1155: AND fee_type <> 'CAPITALIZED';
1156: BEGIN

Line 1501: FROM OKL_FEES_B

1497: AND parent_object_code = 'LEASEQUOTE';
1498:
1499: CURSOR quote_fees_csr(lc_quote_id IN NUMBER) IS
1500: SELECT ID
1501: FROM OKL_FEES_B
1502: WHERE parent_object_id = lc_quote_id
1503: AND parent_object_code = 'LEASEQUOTE'
1504: AND fee_type <> 'CAPITALIZED';
1505:

Line 1797: CURSOR c_check_fee_cash_flow(p_fee_id OKL_FEES_B.ID%TYPE)

1793: WHERE OTY_CODE = 'QUOTED_ASSET'
1794: AND SOURCE_TABLE = 'OKL_ASSETS_B'
1795: AND SOURCE_ID = p_asset_id;
1796:
1797: CURSOR c_check_fee_cash_flow(p_fee_id OKL_FEES_B.ID%TYPE)
1798: IS
1799: SELECT 'YES'
1800: FROM OKL_CASH_FLOW_OBJECTS
1801: WHERE OTY_CODE = 'QUOTED_FEE'

Line 1802: AND SOURCE_TABLE = 'OKL_FEES_B'

1798: IS
1799: SELECT 'YES'
1800: FROM OKL_CASH_FLOW_OBJECTS
1801: WHERE OTY_CODE = 'QUOTED_FEE'
1802: AND SOURCE_TABLE = 'OKL_FEES_B'
1803: AND SOURCE_ID = p_fee_id;
1804:
1805: BEGIN
1806: x_return_status := OKL_API.G_RET_STS_SUCCESS;