APPS.OKL_SUBSIDY_PROCESS_PVT dependencies on FND_DATE

Line 1589: order by FND_DATE.canonical_to_date(sll_rulb.rule_information2);

1585: --and styb.code = 'RENT'
1586: and styb.stream_type_purpose = 'RENT'
1587: and rgpb.cle_id = p_asset_cle_id
1588: and rgpb.rgd_code = 'LALEVL'
1589: order by FND_DATE.canonical_to_date(sll_rulb.rule_information2);
1590:
1591: l_rent_rec l_rent_csr%RowType;
1592: l_payment_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;
1593: lx_payment_tbl OKL_STREAM_GENERATOR_PVT.payment_tbl_type;

Line 1682: l_Payment_tbl(i).start_date := trunc(fnd_date.canonical_to_date(l_rent_rec.start_date));

1678: Loop
1679: fetch l_rent_csr into l_rent_rec;
1680: Exit when l_rent_csr%NOTFOUND;
1681: i := i+1;
1682: l_Payment_tbl(i).start_date := trunc(fnd_date.canonical_to_date(l_rent_rec.start_date));
1683: l_Payment_tbl(i).periods := l_rent_rec.periods;
1684: l_Payment_tbl(i).frequency := l_rent_rec.frequency;
1685: l_payment_tbl(i).structure := l_rent_rec.structure;
1686: l_payment_tbl(i).arrears_yn := l_rent_rec.arrears_yn;

Line 4625: l_inv_review_until_date := fnd_date.canonical_to_date(l_inpr_rec.rule_information2);

4621: l_inv_reason_for_review := null;
4622: l_inv_review_until_date := null;
4623: Else
4624: l_inv_reason_for_review := l_inpr_rec.rule_information1;
4625: l_inv_review_until_date := fnd_date.canonical_to_date(l_inpr_rec.rule_information2);
4626: End If;
4627: close l_rul_csr;
4628:
4629: --------------------------------------------