APPS.OKL_CS_PRINCIPAL_PAYDOWN_PVT dependencies on OKL_CS_PPD_PAYMENTS_UV

Line 2497: FROM okl_cs_ppd_payments_uv

2493: ,start_date
2494: ,stub_days
2495: ,stub_amount
2496: ,advance_payments
2497: FROM okl_cs_ppd_payments_uv
2498: WHERE request_id = c_req_id
2499: AND kle_id=c_kle_id
2500: AND sty_id= c_sty_id
2501: ORDER BY start_date;

Line 2525: FROM okl_cs_ppd_payments_uv

2521: ,arrears
2522: ,amount
2523: ,stub_days
2524: ,stub_amount
2525: FROM okl_cs_ppd_payments_uv
2526: WHERE request_id = c_req_id
2527: AND kle_id=c_kle_id
2528: and start_date > c_start_date
2529: AND sty_id = c_sty_id

Line 2546: FROM okl_cs_ppd_payments_uv

2542: SELECT distinct
2543: frequency_code
2544: ,arrears
2545: ,DECODE(frequency_code,'M',30,'Q',90,'S',180,'A',360)
2546: FROM okl_cs_ppd_payments_uv
2547: WHERE request_id = c_req_id
2548: AND kle_id=c_kle_id
2549: AND sty_id=c_rent_sty_id
2550: AND stub_days is null;

Line 6515: FROM OKL_CS_PPD_PAYMENTS_UV

6511: ,stub_days
6512: ,stub_amount
6513: ,start_date
6514: ,advance_payments
6515: FROM OKL_CS_PPD_PAYMENTS_UV
6516: WHERE request_id = a_id
6517: order by kle_id,sty_id,start_date;
6518:
6519: