APPS.OKL_LEASE_QUOTE_PRICING_PVT dependencies on OKL_FEES_B

Line 1150: FROM OKL_FEES_B

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

Line 1499: FROM OKL_FEES_B

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

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

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

Line 1800: AND SOURCE_TABLE = 'OKL_FEES_B'

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