APPS.OKL_EVERGREEN_BILLING_PVT dependencies on FND_DATE

Line 1683: FND_DATE.canonical_to_date(crl.RULE_INFORMATION2) start_date,

1679: p_chrId NUMBER,
1680: p_cleId NUMBER ) IS
1681: select crl.id slh_id,
1682: DECODE(crl.object1_id1,'M',1,'Q',3,'S',6,'A',12) frequency_factor,
1683: FND_DATE.canonical_to_date(crl.RULE_INFORMATION2) start_date,
1684: TO_NUMBER(crl.RULE_INFORMATION3) periods,
1685: crl.RULE_INFORMATION5 structure,
1686: TO_NUMBER(crl.RULE_INFORMATION7) stub_days,
1687: crl.RULE_INFORMATION10 advance_arrears

Line 1696: and FND_DATE.canonical_to_date(crl.rule_information2) = (select max(FND_DATE.canonical_to_date(crl.RULE_INFORMATION2))

1692: and crg.RGD_CODE = p_rgcode
1693: and crl.RULE_INFORMATION_CATEGORY = p_rlcat
1694: and crg.dnz_chr_id = p_chrId
1695: and nvl(crg.cle_id,-1) = nvl(p_cleId, -1)
1696: and FND_DATE.canonical_to_date(crl.rule_information2) = (select max(FND_DATE.canonical_to_date(crl.RULE_INFORMATION2))
1697: from okc_rules_b crl2
1698: where crl2.rgp_id = crl.rgp_id
1699: and crl2.RULE_INFORMATION_CATEGORY = crl.RULE_INFORMATION_CATEGORY);
1700: