APPS.OKL_LA_SALES_TAX_PVT dependencies on FND_DATE

Line 6508: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,

6504: /* Cursor to get the financed fee top/sub-line payments for a
6505: given contract. */
6506: CURSOR l_fn_fee_pmt_csr (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
6507: p_fee_line_id IN OKL_K_LINES.ID%TYPE) IS
6508: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,
6509: SLL.rule_information3 periods,
6510: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
6511: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
6512: TO_NUMBER(sll.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)) - 1) end_date,

Line 6511: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),

6507: p_fee_line_id IN OKL_K_LINES.ID%TYPE) IS
6508: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,
6509: SLL.rule_information3 periods,
6510: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
6511: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
6512: TO_NUMBER(sll.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)) - 1) end_date,
6513: styt.name stream_type
6514: FROM okc_rules_b sll,
6515: okc_rules_b slh,

Line 6569: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,

6565: AND sty.id = styt.id;
6566:
6567: CURSOR l_strm_sll_csr (p_rule_id OKC_RULES_B.ID%TYPE,
6568: p_rgp_id OKC_RULE_GROUPS_B.ID%TYPE) IS
6569: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,
6570: sll.rule_information1 seq,
6571: sll.rule_information6 amt,
6572: sll.rule_information7 stub_day,
6573: sll.rule_information13 rate