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 1687: from OKL_CASH_FLOW_OBJECTS CFO, OKL_CASH_FLOWS CFL,

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

Line 1700: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

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

Line 1702: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

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

Line 1703: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

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

Line 1715: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

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

Line 1717: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

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

Line 1718: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

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

Line 1730: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

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

Line 1732: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

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

Line 1733: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

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

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

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

Line 1798: select OKL_CASH_FLOWS.due_arrears_yn due_arrears_yn

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

Line 1800: okl_cash_flows, OKL_LEASE_QUOTES_B QUOTE

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

Line 1802: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

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

Line 1812: select OKL_CASH_FLOWS.due_arrears_yn due_arrears_yn

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

Line 1814: okl_cash_flows, OKL_LEASE_QUOTES_B QUOTE

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

Line 1816: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

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

Line 1826: select OKL_CASH_FLOWS.due_arrears_yn due_arrears_yn

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

Line 1828: okl_cash_flows, OKL_LEASE_QUOTES_B QUOTE

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

Line 1830: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

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

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

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

Line 1894: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

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

Line 1896: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

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

Line 1897: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

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

Line 1909: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

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

Line 1911: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

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

Line 1912: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

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

Line 1924: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

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

Line 1926: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

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

Line 1927: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

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

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

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

Line 1990: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

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

Line 1992: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

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

Line 1993: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

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

Line 2005: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

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

Line 2007: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

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

Line 2008: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

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

Line 2020: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

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

Line 2022: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

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

Line 2023: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

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

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

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

Line 2086: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

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

Line 2088: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

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

Line 2089: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

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

Line 2101: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

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

Line 2103: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

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

Line 2104: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

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

Line 2116: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

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

Line 2118: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

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

Line 2119: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

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

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

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

Line 2300: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

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

Line 2302: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

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

Line 2303: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

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

Line 2315: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

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

Line 2317: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

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

Line 2318: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

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

Line 2330: okl_cash_flows, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

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

Line 2332: and OKL_CASH_FLOW_objects.id = okl_cash_flows.CFO_ID

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

Line 2333: and okl_cash_flows.id = OKL_CASH_FLOW_LEVELS.CAF_ID

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

Line 2345: OKL_CASH_FLOWS, OKL_CASH_FLOW_LEVELS, OKL_LEASE_QUOTES_B QUOTE

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

Line 2347: AND OKL_CASH_FLOW_OBJECTS.ID = OKL_CASH_FLOWS.CFO_ID

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

Line 2348: AND OKL_CASH_FLOWS.ID = OKL_CASH_FLOW_LEVELS.CAF_ID

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