DBA Data[Home] [Help]

APPS.OKL_VAR_INT_FLOAT_PVT dependencies on FND_DATE

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

22: FROM okl_k_headers
23: WHERE id = p_contract_id;
24:
25: CURSOR l_payment_line_csr(p_contract_id NUMBER) IS
26: SELECT Fnd_Date.canonical_to_date(rulb2.RULE_INFORMATION2) start_date,
27: rulb2.RULE_INFORMATION3 level_periods,
28: rulb2.RULE_INFORMATION7 stub_days,
29: rulb2.RULE_INFORMATION8 stub_amount,
30: rulb2.object1_id1 frequency

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

1091: AND rul1.rgp_id = rgp.id
1092: AND TO_NUMBER(rul2.object2_id1) = rul1.id
1093: AND TO_NUMBER(rul1.object1_id1) = sty.id
1094: AND sty.stream_type_purpose = 'VARIABLE_INTEREST_SCHEDULE'
1095: ORDER BY FND_DATE.canonical_to_date(rul2.rule_information2);
1096:
1097: l_arrears_pay_dates_option VARCHAR2(50);
1098: l_arrears_yn VARCHAR2(50);
1099: l_invoice_date DATE;