APPS.OKL_CREDIT_DATAPOINTS_PVT dependencies on OKL_CASH_FLOW_OBJECTS

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 1697: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,

1693: AND FND.LOOKUP_TYPE = 'OKL_FREQUENCY';
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

Line 1699: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'

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
1703: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_ASSETS_B'

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 1702: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id

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
1706: and FEE.parent_object_code = 'LEASEQUOTE'

Line 1703: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_ASSETS_B'

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
1706: and FEE.parent_object_code = 'LEASEQUOTE'
1707: and QUOTE.parent_object_code = 'LEASEAPP'

Line 1712: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,

1708: and QUOTE.primary_quote = 'Y'
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

Line 1714: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'

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
1718: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_ASSETS_B'

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 1717: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id

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
1721: and SRV.parent_object_code = 'LEASEQUOTE'

Line 1718: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_ASSETS_B'

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
1721: and SRV.parent_object_code = 'LEASEQUOTE'
1722: and QUOTE.parent_object_code = 'LEASEAPP'

Line 1727: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,

1723: and QUOTE.primary_quote = 'Y'
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

Line 1729: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'

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
1733: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'

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 1732: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id

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
1736: and QUOTE.parent_object_code = 'LEASEAPP'

Line 1733: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'

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
1736: and QUOTE.parent_object_code = 'LEASEAPP'
1737: and QUOTE.primary_quote = 'Y'

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 1797: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,

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
1801: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id

Line 1799: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'

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'
1803: and FEE.parent_object_id = QUOTE.id

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 1801: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id

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
1805: and FEE.parent_object_code = 'LEASEQUOTE'

Line 1802: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'

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
1805: and FEE.parent_object_code = 'LEASEQUOTE'
1806: and QUOTE.parent_object_code = 'LEASEAPP'

Line 1811: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,

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
1815: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id

Line 1813: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'

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'
1817: and SRV.parent_object_id = QUOTE.id

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 1815: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id

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
1819: and SRV.parent_object_code = 'LEASEQUOTE'

Line 1816: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_SERVICES_B'

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
1819: and SRV.parent_object_code = 'LEASEQUOTE'
1820: and QUOTE.parent_object_code = 'LEASEAPP'

Line 1825: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,

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
1829: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id

Line 1827: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'

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'
1831: and INS.LEASE_QUOTE_ID = QUOTE.id

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 1829: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id

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
1833: and QUOTE.parent_object_code = 'LEASEAPP'

Line 1830: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'

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
1833: and QUOTE.parent_object_code = 'LEASEAPP'
1834: and QUOTE.primary_quote = 'Y'

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 1891: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,

1887: and CFO.SOURCE_TABLE = 'OKL_ASSETS_B';
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

Line 1893: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'

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
1897: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'

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 1896: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id

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
1900: and FEE.parent_object_code = 'LEASEQUOTE'

Line 1897: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'

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
1900: and FEE.parent_object_code = 'LEASEQUOTE'
1901: and QUOTE.parent_object_code = 'LEASEAPP'

Line 1906: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,

1902: and QUOTE.primary_quote = 'Y'
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

Line 1908: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'

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
1912: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_SERVICES_B'

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 1911: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id

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
1915: and SRV.parent_object_code = 'LEASEQUOTE'

Line 1912: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_SERVICES_B'

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
1915: and SRV.parent_object_code = 'LEASEQUOTE'
1916: and QUOTE.parent_object_code = 'LEASEAPP'

Line 1921: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,

1917: and QUOTE.primary_quote = 'Y'
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

Line 1923: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'

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
1927: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'

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 1926: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id

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
1930: and QUOTE.parent_object_code = 'LEASEAPP'

Line 1927: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'

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
1930: and QUOTE.parent_object_code = 'LEASEAPP'
1931: and QUOTE.primary_quote = 'Y'

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 1987: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,

1983: and CFO.SOURCE_TABLE = 'OKL_ASSETS_B';
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

Line 1989: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'

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
1993: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'

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 1992: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id

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
1996: and FEE.parent_object_code = 'LEASEQUOTE'

Line 1993: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'

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
1996: and FEE.parent_object_code = 'LEASEQUOTE'
1997: and QUOTE.parent_object_code = 'LEASEAPP'

Line 2002: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,

1998: and QUOTE.primary_quote = 'Y'
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

Line 2004: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'

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
2008: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_SERVICES_B'

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 2007: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id

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
2011: and SRV.parent_object_code = 'LEASEQUOTE'

Line 2008: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_SERVICES_B'

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
2011: and SRV.parent_object_code = 'LEASEQUOTE'
2012: and QUOTE.parent_object_code = 'LEASEAPP'

Line 2017: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,

2013: and QUOTE.primary_quote = 'Y'
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

Line 2019: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'

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
2023: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'

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 2022: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id

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
2026: and QUOTE.parent_object_code = 'LEASEAPP'

Line 2023: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'

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
2026: and QUOTE.parent_object_code = 'LEASEAPP'
2027: and QUOTE.primary_quote = 'Y'

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 2083: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,

2079: and CFO.SOURCE_TABLE = 'OKL_ASSETS_B';
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

Line 2085: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'

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
2089: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'

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 2088: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id

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
2092: and FEE.parent_object_code = 'LEASEQUOTE'

Line 2089: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'

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
2092: and FEE.parent_object_code = 'LEASEQUOTE'
2093: and QUOTE.parent_object_code = 'LEASEAPP'

Line 2098: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,

2094: and QUOTE.primary_quote = 'Y'
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

Line 2100: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'

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
2104: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_SERVICES_B'

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 2103: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id

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
2107: and SRV.parent_object_code = 'LEASEQUOTE'

Line 2104: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_SERVICES_B'

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
2107: and SRV.parent_object_code = 'LEASEQUOTE'
2108: and QUOTE.parent_object_code = 'LEASEAPP'

Line 2113: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,

2109: and QUOTE.primary_quote = 'Y'
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

Line 2115: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'

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
2119: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'

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 2118: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id

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
2122: and QUOTE.parent_object_code = 'LEASEAPP'

Line 2119: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'

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
2122: and QUOTE.parent_object_code = 'LEASEAPP'
2123: and QUOTE.primary_quote = 'Y'

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 2296: from okl_lease_applications_b LAP, OKL_FEES_B FEE, OKL_CASH_FLOW_OBJECTS,

2292: and CFO.SOURCE_TABLE = 'OKL_ASSETS_B';
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

Line 2298: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_FEE'

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
2302: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'

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 2301: and OKL_CASH_FLOW_OBJECTS.source_id = FEE.id

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
2305: and FEE.parent_object_code = 'LEASEQUOTE'

Line 2302: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_FEES_B'

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
2305: and FEE.parent_object_code = 'LEASEQUOTE'
2306: and QUOTE.parent_object_code = 'LEASEAPP'

Line 2311: from okl_lease_applications_b LAP, OKL_SERVICES_B SRV, OKL_CASH_FLOW_OBJECTS,

2307: and QUOTE.primary_quote = 'Y'
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

Line 2313: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_SERVICE'

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
2317: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_SERVICES_B'

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 2316: and OKL_CASH_FLOW_OBJECTS.source_id = SRV.id

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
2320: and SRV.parent_object_code = 'LEASEQUOTE'

Line 2317: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_SERVICES_B'

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
2320: and SRV.parent_object_code = 'LEASEQUOTE'
2321: and QUOTE.parent_object_code = 'LEASEAPP'

Line 2326: from okl_lease_applications_b LAP, OKL_INSURANCE_ESTIMATES_B INS, OKL_CASH_FLOW_OBJECTS,

2322: and QUOTE.primary_quote = 'Y'
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

Line 2328: where OKL_CASH_FLOW_objects.OTY_CODE = 'QUOTED_INSURANCE'

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
2332: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'

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 2331: and OKL_CASH_FLOW_OBJECTS.source_id = INS.id

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
2335: and QUOTE.parent_object_code = 'LEASEAPP'

Line 2332: and OKL_CASH_FLOW_OBJECTS.source_table = 'OKL_INSURANCE_ESTIMATES_B'

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
2335: and QUOTE.parent_object_code = 'LEASEAPP'
2336: and QUOTE.primary_quote = 'Y'

Line 2341: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET, OKL_CASH_FLOW_OBJECTS,

2337: and LAP.id = l_lease_app_id;*/
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

Line 2343: WHERE OKL_CASH_FLOW_OBJECTS.OTY_CODE = 'QUOTED_ASSET'

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
2347: AND OKL_CASH_FLOW_OBJECTS.SOURCE_TABLE = 'OKL_ASSETS_B'

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 2346: AND OKL_CASH_FLOW_OBJECTS.SOURCE_ID = ASSET.ID

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
2350: AND ASSET.PARENT_OBJECT_CODE = 'LEASEQUOTE'

Line 2347: AND OKL_CASH_FLOW_OBJECTS.SOURCE_TABLE = 'OKL_ASSETS_B'

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
2350: AND ASSET.PARENT_OBJECT_CODE = 'LEASEQUOTE'
2351: AND QUOTE.PARENT_OBJECT_CODE = 'LEASEAPP'