APPS.OKL_CREDIT_DATAPOINTS_PVT dependencies on OKL_CASH_FLOW_LEVELS

Line 1688: OKL_CASH_FLOW_LEVELS LVL, FND_LOOKUPS FND

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
1692: and CFO.SOURCE_ID = l_asset_id

Line 1698: select OKL_CASH_FLOW_LEVELS.FQY_CODE FQY_CODE

1694: AND LVL.FQY_CODE = FND.LOOKUP_CODE
1695: AND FND.LOOKUP_TYPE = 'OKL_FREQUENCY';
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

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 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 1713: select OKL_CASH_FLOW_LEVELS.FQY_CODE FQY_CODE

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

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 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 1728: select OKL_CASH_FLOW_LEVELS.FQY_CODE FQY_CODE

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

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 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 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 1892: select OKL_CASH_FLOW_LEVELS.number_of_periods number_of_periods

1888: and CFO.SOURCE_ID = l_asset_id
1889: and CFO.SOURCE_TABLE = 'OKL_ASSETS_B';
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

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 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 1907: select OKL_CASH_FLOW_LEVELS.number_of_periods number_of_periods

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

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 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 1922: select OKL_CASH_FLOW_LEVELS.number_of_periods number_of_periods

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

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 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 1988: select OKL_CASH_FLOW_LEVELS.amount amount

1984: and CFO.SOURCE_ID = l_asset_id
1985: and CFO.SOURCE_TABLE = 'OKL_ASSETS_B';
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

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 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 2003: select OKL_CASH_FLOW_LEVELS.amount amount

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

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 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 2018: select OKL_CASH_FLOW_LEVELS.amount amount

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

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 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 2084: select OKL_CASH_FLOW_LEVELS.start_date start_date

2080: and CFO.SOURCE_ID = l_asset_id
2081: and CFO.SOURCE_TABLE = 'OKL_ASSETS_B';
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

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 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 2099: select OKL_CASH_FLOW_LEVELS.start_date start_date

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

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 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 2114: select OKL_CASH_FLOW_LEVELS.start_date start_date

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

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 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 2298: select OKL_CASH_FLOW_LEVELS.start_date end_date

2294: and CFO.SOURCE_TABLE = 'OKL_ASSETS_B'
2295: order by LVL.start_date; --Bug # 9116306
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

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 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 2313: select OKL_CASH_FLOW_LEVELS.start_date end_date

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

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 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 2328: select OKL_CASH_FLOW_LEVELS.start_date end_date

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

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 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 2343: SELECT OKL_CASH_FLOW_LEVELS.FQY_CODE FQY_CODE, QUOTE.TERM

2339: and QUOTE.primary_quote = 'Y'
2340: and LAP.id = l_lease_app_id;*/
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

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 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

Line 2365: l_freq_code OKL_CASH_FLOW_LEVELS.FQY_CODE%TYPE;

2361: i BINARY_INTEGER := 0;
2362:
2363: cf_level_tbl OKL_LEASE_QUOTE_CASHFLOW_PVT.cashflow_level_tbl_type;
2364:
2365: l_freq_code OKL_CASH_FLOW_LEVELS.FQY_CODE%TYPE;
2366: l_term NUMBER;
2367: l_return_status VARCHAR2(1);
2368: BEGIN
2369: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452