APPS.OKL_CREDIT_DATAPOINTS_PVT dependencies on OKL_COST_ADJUSTMENTS_B

Line 1511: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE

1507: BEGIN
1508: SELECT NVL(SUM(ADJ.VALUE), 0)
1509: INTO l_down_payment_amount
1510: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
1511: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE
1512: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'DOWN_PAYMENT'
1513: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
1514: AND ADJ.PARENT_OBJECT_ID = ASSET.ID
1515: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID

Line 1551: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE

1547: BEGIN
1548: SELECT SUM(DECODE(ADJ.VALUE, NULL, ADJ.DEFAULT_SUBSIDY_AMOUNT, ADJ.VALUE)) SUBSIDY_AMOUNT
1549: INTO l_subsidy_amount
1550: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
1551: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE
1552: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'SUBSIDY'
1553: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
1554: AND ADJ.PARENT_OBJECT_ID = ASSET.ID
1555: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID

Line 1592: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE

1588: BEGIN
1589: SELECT NVL(SUM(ADJ.VALUE), 0)
1590: INTO l_trade_in_amount
1591: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
1592: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE
1593: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'TRADEIN'
1594: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
1595: AND ADJ.PARENT_OBJECT_ID = ASSET.ID
1596: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID

Line 1629: OKL_LEASE_QUOTES_B QUOTE, OKL_COST_ADJUSTMENTS_B ADJ

1625:
1626: CURSOR cAssetNumber IS
1627: SELECT ASSET.ASSET_NUMBER
1628: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
1629: OKL_LEASE_QUOTES_B QUOTE, OKL_COST_ADJUSTMENTS_B ADJ
1630: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE = 'TRADEIN'
1631: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
1632: AND ADJ.PARENT_OBJECT_ID = ASSET.ID
1633: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID

Line 2669: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE

2665: -- added for bug 6596860 --
2666: CURSOR l_adj_sum_csr(p_lease_app_id IN NUMBER) IS
2667: SELECT NVL(SUM(VALUE),0 )
2668: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
2669: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE
2670: WHERE ADJ.PARENT_OBJECT_CODE = 'ASSET'
2671: AND ADJ.PARENT_OBJECT_ID = ASSET.ID
2672: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID
2673: AND QUOTE.PARENT_OBJECT_ID = LAP.ID

Line 2774: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE

2770: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2771: SELECT NVL(SUM(ADJ.VALUE), 0)
2772: INTO ln_down_payment_amount
2773: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,
2774: OKL_COST_ADJUSTMENTS_B ADJ, OKL_LEASE_QUOTES_B QUOTE
2775: WHERE ADJ.ADJUSTMENT_SOURCE_TYPE IN ('DOWN_PAYMENT', 'TRADEIN')
2776: AND ADJ.PARENT_OBJECT_CODE = 'ASSET'
2777: AND ADJ.PARENT_OBJECT_ID = ASSET.ID
2778: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID