DBA Data[Home] [Help]

APPS.OKL_VARIABLE_INTEREST_PVT dependencies on FND_DATE

Line 2814: SELECT Fnd_Date.canonical_to_date(rulb2.RULE_INFORMATION2) start_date,

2810: FUNCTION get_next_period_start_date(p_khr_id IN NUMBER,
2811: p_start_date IN DATE) RETURN DATE IS
2812:
2813: CURSOR l_payment_line_csr(p_contract_id NUMBER, p_cle_id NUMBER) IS
2814: SELECT Fnd_Date.canonical_to_date(rulb2.RULE_INFORMATION2) start_date,
2815: rulb2.RULE_INFORMATION3 level_periods,
2816: rulb2.RULE_INFORMATION7 stub_days,
2817: rulb2.RULE_INFORMATION8 stub_amount,
2818: rulb2.object1_id1 frequency

Line 6472: ORDER BY FND_DATE.canonical_to_date(rul2.rule_information2);

6468: AND rul1.rgp_id = rgp.id
6469: AND TO_NUMBER(rul2.object2_id1) = rul1.id
6470: AND TO_NUMBER(rul1.object1_id1) = sty.id
6471: AND sty.stream_type_purpose = 'VARIABLE_INTEREST_SCHEDULE'
6472: ORDER BY FND_DATE.canonical_to_date(rul2.rule_information2);
6473:
6474: l_arrears_pay_dates_option VARCHAR2(50);
6475: l_arrears_yn VARCHAR2(50);
6476: l_invoice_date DATE;