DBA Data[Home] [Help]

APPS.OKC_RENEW_PVT dependencies on FND_DATE

Line 3007: fnd_date.Canonical_To_Date(rul.rule_information3) ultimate_end_date

3003:
3004: -- Cursor modified for Bug 2292300
3005: CURSOR cur_rules(p_chr_id number) is
3006: SELECT nvl(rul.rule_information1, OKC_API.G_MISS_CHAR) renew_type,
3007: fnd_date.Canonical_To_Date(rul.rule_information3) ultimate_end_date
3008: --To_Date(rul.rule_information3, 'YYYY/MM/DD') ultimate_end_date
3009: FROM okc_rules_b rul,
3010: okc_rule_groups_b rgp
3011: WHERE rgp.dnz_chr_id = p_chr_id