APPS.OKL_GENERATE_PV_RENT_PVT dependencies on FND_DATE

Line 519: FND_DATE.canonical_to_date(sll.rule_information2) start_date,

515: ------------------------------------------------------------
516:
517: CURSOR c_payment_details_csr (p_khr_id NUMBER, p_kle_id NUMBER) IS
518: SELECT rgp.cle_id cle_id, sty.stream_type_purpose, sty.id sty_id,
519: FND_DATE.canonical_to_date(sll.rule_information2) start_date,
520: TO_NUMBER(SLL.rule_information3) periods,
521: sll.object1_id1 frequency,
522: sll.rule_information5 structure,
523: NVL(sll.rule_information10, 'N') arrears_yn,

Line 545: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);

541: AND (sty.stream_type_purpose = 'RENT'
542: or sty.stream_type_purpose = 'DOWN_PAYMENT')
543: AND TO_CHAR(slh.id) = sll.object2_id1
544: AND sll.rule_information_category = 'LASLL'
545: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);
546:
547: l_payment_details_csr_rec c_payment_details_csr%ROWTYPE;
548:
549: l_cash_inflow_tbl cash_flow_tbl;