APPS.OKL_GENERATE_PV_RENT_PVT dependencies on FND_DATE

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

509: ------------------------------------------------------------
510:
511: CURSOR c_payment_details_csr (p_khr_id NUMBER, p_kle_id NUMBER) IS
512: SELECT rgp.cle_id cle_id, sty.stream_type_purpose, sty.id sty_id,
513: FND_DATE.canonical_to_date(sll.rule_information2) start_date,
514: TO_NUMBER(SLL.rule_information3) periods,
515: sll.object1_id1 frequency,
516: sll.rule_information5 structure,
517: NVL(sll.rule_information10, 'N') arrears_yn,

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

535: AND (sty.stream_type_purpose = 'RENT'
536: or sty.stream_type_purpose = 'DOWN_PAYMENT')
537: AND TO_CHAR(slh.id) = sll.object2_id1
538: AND sll.rule_information_category = 'LASLL'
539: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);
540:
541: l_payment_details_csr_rec c_payment_details_csr%ROWTYPE;
542:
543: l_cash_inflow_tbl cash_flow_tbl;