eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CREDIT_DATAPOINTS_PVT dependencies on OKL_CASH_FLOWS

Line 1685: from OKL_CASH_FLOW_OBJECTS CFO, OKL_CASH_FLOWS CFL,

1681: l_pmnt_frequency VARCHAR2(30);
1682:
1683: cursor cPmntFreq is
1684: select FND.MEANING frequency
1685: from OKL_CASH_FLOW_OBJECTS CFO, OKL_CASH_FLOWS CFL,
1686: OKL_CASH_FLOW_LEVELS LVL, FND_LOOKUPS FND
1687: where CFO.OTY_CODE = 'QUOTED_ASSET'
1688: and CFO.ID = CFL.CFO_ID
1689: and CFL.ID = LVL.CAF_ID

Line 1698: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

1694:
1695: /*UNION
1696: select OKL_CASH_FLOW_LEVELS.FQY_CODE FQY_CODE
1697: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
1698: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1699: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
1700: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1701: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1702: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id

Line 1700: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

1696: select OKL_CASH_FLOW_LEVELS.FQY_CODE FQY_CODE
1697: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
1698: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1699: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
1700: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1701: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1702: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id
1703: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_ASSETS_B'
1704: and FEE.parent_object_id = QUOTE.id

Line 1701: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

1697: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
1698: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1699: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
1700: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1701: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1702: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id
1703: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_ASSETS_B'
1704: and FEE.parent_object_id = QUOTE.id
1705: and QUOTE.parent_object_id = LAP.id

Line 1713: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

1709: and LAP.id = l_lease_app_id
1710: UNION
1711: select OKL_CASH_FLOW_LEVELS.FQY_CODE FQY_CODE
1712: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,
1713: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1714: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'
1715: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1716: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1717: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id

Line 1715: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

1711: select OKL_CASH_FLOW_LEVELS.FQY_CODE FQY_CODE
1712: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,
1713: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1714: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'
1715: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1716: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1717: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id
1718: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_ASSETS_B'
1719: and SRV.parent_object_id = QUOTE.id

Line 1716: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

1712: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,
1713: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1714: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'
1715: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1716: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1717: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id
1718: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_ASSETS_B'
1719: and SRV.parent_object_id = QUOTE.id
1720: and QUOTE.parent_object_id = LAP.id

Line 1728: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

1724: and LAP.id = l_lease_app_id
1725: UNION
1726: select OKL_CASH_FLOW_LEVELS.FQY_CODE FQY_CODE
1727: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,
1728: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1729: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'
1730: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1731: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1732: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id

Line 1730: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

1726: select OKL_CASH_FLOW_LEVELS.FQY_CODE FQY_CODE
1727: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,
1728: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1729: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'
1730: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1731: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1732: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id
1733: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'
1734: and INS.LEASE_QUOTE_ID = QUOTE.id

Line 1731: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

1727: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,
1728: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1729: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'
1730: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1731: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1732: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id
1733: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'
1734: and INS.LEASE_QUOTE_ID = QUOTE.id
1735: and QUOTE.parent_object_id = LAP.id

Line 1784: from OKL_CASH_FLOW_OBJECTS CFO, OKL_CASH_FLOWS CFL, FND_LOOKUPS FND

1780: l_pmnt_arrears_yn VARCHAR2(3);
1781:
1782: cursor cPmntArrYN is
1783: select FND.MEANING Arrears
1784: from OKL_CASH_FLOW_OBJECTS CFO, OKL_CASH_FLOWS CFL, FND_LOOKUPS FND
1785: where CFO.OTY_CODE = 'QUOTED_ASSET'
1786: and CFO.id = CFL.CFO_ID
1787: --Bug 7030452 :Hardcoded value '23' is removed
1788: -- and CFO.source_id = 23

Line 1796: select OKL_CASH_FLOWS.due_arrears_yn due_arrears_yn

1792: AND CFL.due_arrears_yn = FND.LOOKUP_CODE
1793: AND FND.LOOKUP_TYPE = 'OKL_YES_NO';
1794:
1795: /*union
1796: select OKL_CASH_FLOWS.due_arrears_yn due_arrears_yn
1797: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
1798: okl_cash_flows, OKL_LEASE_QUOTES_B QUOTE
1799: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
1800: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

Line 1798: okl_cash_flows, OKL_LEASE_QUOTES_B QUOTE

1794:
1795: /*union
1796: select OKL_CASH_FLOWS.due_arrears_yn due_arrears_yn
1797: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
1798: okl_cash_flows, OKL_LEASE_QUOTES_B QUOTE
1799: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
1800: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1801: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id
1802: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'

Line 1800: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

1796: select OKL_CASH_FLOWS.due_arrears_yn due_arrears_yn
1797: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
1798: okl_cash_flows, OKL_LEASE_QUOTES_B QUOTE
1799: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
1800: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1801: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id
1802: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'
1803: and FEE.parent_object_id = QUOTE.id
1804: and QUOTE.parent_object_id = LAP.id

Line 1810: select OKL_CASH_FLOWS.due_arrears_yn due_arrears_yn

1806: and QUOTE.parent_object_code = 'LEASEAPP'
1807: and QUOTE.primary_quote = 'Y'
1808: and LAP.id = l_lease_app_id
1809: union
1810: select OKL_CASH_FLOWS.due_arrears_yn due_arrears_yn
1811: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,
1812: okl_cash_flows, OKL_LEASE_QUOTES_B QUOTE
1813: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'
1814: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

Line 1812: okl_cash_flows, OKL_LEASE_QUOTES_B QUOTE

1808: and LAP.id = l_lease_app_id
1809: union
1810: select OKL_CASH_FLOWS.due_arrears_yn due_arrears_yn
1811: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,
1812: okl_cash_flows, OKL_LEASE_QUOTES_B QUOTE
1813: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'
1814: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1815: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id
1816: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_SERVICES_B'

Line 1814: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

1810: select OKL_CASH_FLOWS.due_arrears_yn due_arrears_yn
1811: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,
1812: okl_cash_flows, OKL_LEASE_QUOTES_B QUOTE
1813: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'
1814: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1815: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id
1816: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_SERVICES_B'
1817: and SRV.parent_object_id = QUOTE.id
1818: and QUOTE.parent_object_id = LAP.id

Line 1824: select OKL_CASH_FLOWS.due_arrears_yn due_arrears_yn

1820: and QUOTE.parent_object_code = 'LEASEAPP'
1821: and QUOTE.primary_quote = 'Y'
1822: and LAP.id = l_lease_app_id
1823: union
1824: select OKL_CASH_FLOWS.due_arrears_yn due_arrears_yn
1825: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,
1826: okl_cash_flows, OKL_LEASE_QUOTES_B QUOTE
1827: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'
1828: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

Line 1826: okl_cash_flows, OKL_LEASE_QUOTES_B QUOTE

1822: and LAP.id = l_lease_app_id
1823: union
1824: select OKL_CASH_FLOWS.due_arrears_yn due_arrears_yn
1825: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,
1826: okl_cash_flows, OKL_LEASE_QUOTES_B QUOTE
1827: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'
1828: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1829: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id
1830: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'

Line 1828: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

1824: select OKL_CASH_FLOWS.due_arrears_yn due_arrears_yn
1825: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,
1826: okl_cash_flows, OKL_LEASE_QUOTES_B QUOTE
1827: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'
1828: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1829: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id
1830: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'
1831: and INS.LEASE_QUOTE_ID = QUOTE.id
1832: and QUOTE.parent_object_id = LAP.id

Line 1882: from OKL_CASH_FLOW_OBJECTS CFO, OKL_CASH_FLOWS CFL, OKL_CASH_FLOW_LEVELS LVL

1878: l_pmnt_periods NUMBER;
1879:
1880: cursor cPmntPeriods is
1881: select LVL.NUMBER_OF_PERIODS
1882: from OKL_CASH_FLOW_OBJECTS CFO, OKL_CASH_FLOWS CFL, OKL_CASH_FLOW_LEVELS LVL
1883: where CFO.OTY_CODE = 'QUOTED_ASSET'
1884: and CFO.ID = CFL.CFO_ID
1885: and CFL.ID = LVL.CAF_ID
1886: and CFO.SOURCE_ID = l_asset_id

Line 1892: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

1888:
1889: /*union
1890: select OKL_CASH_FLOW_LEVELS.number_of_periods number_of_periods
1891: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
1892: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1893: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
1894: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1895: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1896: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id

Line 1894: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

1890: select OKL_CASH_FLOW_LEVELS.number_of_periods number_of_periods
1891: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
1892: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1893: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
1894: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1895: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1896: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id
1897: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'
1898: and FEE.parent_object_id = QUOTE.id

Line 1895: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

1891: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
1892: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1893: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
1894: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1895: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1896: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id
1897: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'
1898: and FEE.parent_object_id = QUOTE.id
1899: and QUOTE.parent_object_id = LAP.id

Line 1907: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

1903: and LAP.id = l_lease_app_id
1904: union
1905: select OKL_CASH_FLOW_LEVELS.number_of_periods number_of_periods
1906: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,
1907: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1908: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'
1909: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1910: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1911: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id

Line 1909: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

1905: select OKL_CASH_FLOW_LEVELS.number_of_periods number_of_periods
1906: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,
1907: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1908: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'
1909: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1910: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1911: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id
1912: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_SERVICES_B'
1913: and SRV.parent_object_id = QUOTE.id

Line 1910: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

1906: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,
1907: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1908: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'
1909: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1910: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1911: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id
1912: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_SERVICES_B'
1913: and SRV.parent_object_id = QUOTE.id
1914: and QUOTE.parent_object_id = LAP.id

Line 1922: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

1918: and LAP.id = l_lease_app_id
1919: union
1920: select OKL_CASH_FLOW_LEVELS.number_of_periods number_of_periods
1921: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,
1922: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1923: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'
1924: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1925: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1926: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id

Line 1924: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

1920: select OKL_CASH_FLOW_LEVELS.number_of_periods number_of_periods
1921: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,
1922: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1923: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'
1924: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1925: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1926: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id
1927: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'
1928: and INS.LEASE_QUOTE_ID = QUOTE.id

Line 1925: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

1921: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,
1922: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1923: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'
1924: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1925: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1926: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id
1927: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'
1928: and INS.LEASE_QUOTE_ID = QUOTE.id
1929: and QUOTE.parent_object_id = LAP.id

Line 1978: from OKL_CASH_FLOW_OBJECTS CFO, OKL_CASH_FLOWS CFL, OKL_CASH_FLOW_LEVELS LVL

1974: l_pmnt_amounts NUMBER;
1975:
1976: cursor cPmntAmount is
1977: select LVL.AMOUNT
1978: from OKL_CASH_FLOW_OBJECTS CFO, OKL_CASH_FLOWS CFL, OKL_CASH_FLOW_LEVELS LVL
1979: where CFO.OTY_CODE = 'QUOTED_ASSET'
1980: and CFO.ID = CFL.CFO_ID
1981: and CFL.ID = LVL.CAF_ID
1982: and CFO.SOURCE_ID = l_asset_id

Line 1988: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

1984:
1985: /*union
1986: select OKL_CASH_FLOW_LEVELS.amount amount
1987: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
1988: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1989: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
1990: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1991: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1992: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id

Line 1990: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

1986: select OKL_CASH_FLOW_LEVELS.amount amount
1987: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
1988: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1989: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
1990: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1991: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1992: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id
1993: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'
1994: and FEE.parent_object_id = QUOTE.id

Line 1991: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

1987: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
1988: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
1989: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
1990: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
1991: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
1992: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id
1993: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'
1994: and FEE.parent_object_id = QUOTE.id
1995: and QUOTE.parent_object_id = LAP.id

Line 2003: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

1999: and LAP.id = l_lease_app_id
2000: union
2001: select OKL_CASH_FLOW_LEVELS.amount amount
2002: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,
2003: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2004: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'
2005: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2006: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2007: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id

Line 2005: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

2001: select OKL_CASH_FLOW_LEVELS.amount amount
2002: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,
2003: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2004: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'
2005: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2006: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2007: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id
2008: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_SERVICES_B'
2009: and SRV.parent_object_id = QUOTE.id

Line 2006: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

2002: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,
2003: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2004: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'
2005: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2006: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2007: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id
2008: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_SERVICES_B'
2009: and SRV.parent_object_id = QUOTE.id
2010: and QUOTE.parent_object_id = LAP.id

Line 2018: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

2014: and LAP.id = l_lease_app_id
2015: union
2016: select OKL_CASH_FLOW_LEVELS.amount amount
2017: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,
2018: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2019: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'
2020: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2021: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2022: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id

Line 2020: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

2016: select OKL_CASH_FLOW_LEVELS.amount amount
2017: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,
2018: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2019: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'
2020: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2021: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2022: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id
2023: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'
2024: and INS.LEASE_QUOTE_ID = QUOTE.id

Line 2021: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

2017: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,
2018: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2019: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'
2020: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2021: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2022: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id
2023: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'
2024: and INS.LEASE_QUOTE_ID = QUOTE.id
2025: and QUOTE.parent_object_id = LAP.id

Line 2074: from OKL_CASH_FLOW_OBJECTS CFO, OKL_CASH_FLOWS CFL, OKL_CASH_FLOW_LEVELS LVL

2070: l_pmnt_start_date DATE;
2071:
2072: cursor cPmntStartDate is
2073: select LVL.start_date
2074: from OKL_CASH_FLOW_OBJECTS CFO, OKL_CASH_FLOWS CFL, OKL_CASH_FLOW_LEVELS LVL
2075: where CFO.OTY_CODE = 'QUOTED_ASSET'
2076: and CFO.ID = CFL.CFO_ID
2077: and CFL.ID = LVL.CAF_ID
2078: and CFO.SOURCE_ID = l_asset_id

Line 2084: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

2080:
2081: /*union
2082: select OKL_CASH_FLOW_LEVELS.start_date start_date
2083: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
2084: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2085: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
2086: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2087: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2088: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id

Line 2086: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

2082: select OKL_CASH_FLOW_LEVELS.start_date start_date
2083: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
2084: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2085: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
2086: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2087: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2088: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id
2089: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'
2090: and FEE.parent_object_id = QUOTE.id

Line 2087: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

2083: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
2084: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2085: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
2086: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2087: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2088: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id
2089: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'
2090: and FEE.parent_object_id = QUOTE.id
2091: and QUOTE.parent_object_id = LAP.id

Line 2099: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

2095: and LAP.id = l_lease_app_id
2096: union
2097: select OKL_CASH_FLOW_LEVELS.start_date start_date
2098: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,
2099: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2100: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'
2101: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2102: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2103: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id

Line 2101: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

2097: select OKL_CASH_FLOW_LEVELS.start_date start_date
2098: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,
2099: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2100: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'
2101: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2102: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2103: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id
2104: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_SERVICES_B'
2105: and SRV.parent_object_id = QUOTE.id

Line 2102: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

2098: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,
2099: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2100: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'
2101: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2102: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2103: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id
2104: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_SERVICES_B'
2105: and SRV.parent_object_id = QUOTE.id
2106: and QUOTE.parent_object_id = LAP.id

Line 2114: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

2110: and LAP.id = l_lease_app_id
2111: union
2112: select OKL_CASH_FLOW_LEVELS.start_date start_date
2113: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,
2114: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2115: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'
2116: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2117: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2118: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id

Line 2116: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

2112: select OKL_CASH_FLOW_LEVELS.start_date start_date
2113: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,
2114: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2115: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'
2116: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2117: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2118: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id
2119: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'
2120: and INS.LEASE_QUOTE_ID = QUOTE.id

Line 2117: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

2113: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,
2114: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2115: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'
2116: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2117: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2118: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id
2119: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'
2120: and INS.LEASE_QUOTE_ID = QUOTE.id
2121: and QUOTE.parent_object_id = LAP.id

Line 2287: from OKL_CASH_FLOW_OBJECTS CFO, OKL_CASH_FLOWS CFL, OKL_CASH_FLOW_LEVELS LVL

2283: l_pmnt_end_date DATE;
2284:
2285: cursor c_level_data is
2286: select LVL.stub_days, LVL.number_of_periods, LVL.start_date
2287: from OKL_CASH_FLOW_OBJECTS CFO, OKL_CASH_FLOWS CFL, OKL_CASH_FLOW_LEVELS LVL
2288: where CFO.OTY_CODE = 'QUOTED_ASSET'
2289: and CFO.ID = CFL.CFO_ID
2290: and CFL.ID = LVL.CAF_ID
2291: and CFO.SOURCE_ID = l_asset_id

Line 2297: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

2293:
2294: /*union
2295: select OKL_CASH_FLOW_LEVELS.start_date end_date
2296: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
2297: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2298: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
2299: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2300: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2301: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id

Line 2299: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

2295: select OKL_CASH_FLOW_LEVELS.start_date end_date
2296: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
2297: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2298: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
2299: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2300: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2301: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id
2302: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'
2303: and FEE.parent_object_id = QUOTE.id

Line 2300: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

2296: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,
2297: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2298: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'
2299: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2300: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2301: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id
2302: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'
2303: and FEE.parent_object_id = QUOTE.id
2304: and QUOTE.parent_object_id = LAP.id

Line 2312: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

2308: and LAP.id = l_lease_app_id
2309: union
2310: select OKL_CASH_FLOW_LEVELS.start_date end_date
2311: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,
2312: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2313: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'
2314: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2315: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2316: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id

Line 2314: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

2310: select OKL_CASH_FLOW_LEVELS.start_date end_date
2311: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,
2312: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2313: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'
2314: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2315: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2316: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id
2317: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_SERVICES_B'
2318: and SRV.parent_object_id = QUOTE.id

Line 2315: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

2311: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,
2312: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2313: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'
2314: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2315: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2316: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id
2317: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_SERVICES_B'
2318: and SRV.parent_object_id = QUOTE.id
2319: and QUOTE.parent_object_id = LAP.id

Line 2327: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

2323: and LAP.id = l_lease_app_id
2324: union
2325: select OKL_CASH_FLOW_LEVELS.start_date end_date
2326: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,
2327: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2328: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'
2329: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2330: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2331: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id

Line 2329: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

2325: select OKL_CASH_FLOW_LEVELS.start_date end_date
2326: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,
2327: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2328: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'
2329: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2330: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2331: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id
2332: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'
2333: and INS.LEASE_QUOTE_ID = QUOTE.id

Line 2330: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

2326: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,
2327: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2328: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'
2329: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID
2330: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID
2331: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id
2332: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'
2333: and INS.LEASE_QUOTE_ID = QUOTE.id
2334: and QUOTE.parent_object_id = LAP.id

Line 2342: OKL_CASH_FLOWS, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

2338:
2339: CURSOR c_get_info IS
2340: SELECT OKL_CASH_FLOW_LEVELS.FQY_CODE FQY_CODE, QUOTE.TERM
2341: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET, OKL_CASH_FLOW_OBJECTS,
2342: OKL_CASH_FLOWS, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2343: WHERE OKL_CASH_FLOW_OBJECTS.OTY_CODE = 'QUOTED_ASSET'
2344: AND OKL_CASH_FLOW_OBJECTS.ID = OKL_CASH_FLOWS.CFO_ID
2345: AND OKL_CASH_FLOWS.ID = OKL_CASH_FLOW_LEVELS.CAF_ID
2346: AND OKL_CASH_FLOW_OBJECTS.SOURCE_ID = ASSET.ID

Line 2344: AND OKL_CASH_FLOW_OBJECTS.ID = OKL_CASH_FLOWS.CFO_ID

2340: SELECT OKL_CASH_FLOW_LEVELS.FQY_CODE FQY_CODE, QUOTE.TERM
2341: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET, OKL_CASH_FLOW_OBJECTS,
2342: OKL_CASH_FLOWS, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2343: WHERE OKL_CASH_FLOW_OBJECTS.OTY_CODE = 'QUOTED_ASSET'
2344: AND OKL_CASH_FLOW_OBJECTS.ID = OKL_CASH_FLOWS.CFO_ID
2345: AND OKL_CASH_FLOWS.ID = OKL_CASH_FLOW_LEVELS.CAF_ID
2346: AND OKL_CASH_FLOW_OBJECTS.SOURCE_ID = ASSET.ID
2347: AND OKL_CASH_FLOW_OBJECTS.SOURCE_TABLE = 'OKL_ASSETS_B'
2348: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID

Line 2345: AND OKL_CASH_FLOWS.ID = OKL_CASH_FLOW_LEVELS.CAF_ID

2341: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET, OKL_CASH_FLOW_OBJECTS,
2342: OKL_CASH_FLOWS, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE
2343: WHERE OKL_CASH_FLOW_OBJECTS.OTY_CODE = 'QUOTED_ASSET'
2344: AND OKL_CASH_FLOW_OBJECTS.ID = OKL_CASH_FLOWS.CFO_ID
2345: AND OKL_CASH_FLOWS.ID = OKL_CASH_FLOW_LEVELS.CAF_ID
2346: AND OKL_CASH_FLOW_OBJECTS.SOURCE_ID = ASSET.ID
2347: AND OKL_CASH_FLOW_OBJECTS.SOURCE_TABLE = 'OKL_ASSETS_B'
2348: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID
2349: AND QUOTE.PARENT_OBJECT_ID = LAP.ID