eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_STREAM_GENERATOR_PVT dependencies on FND_DATE

Line 765: FND_DATE.canonical_to_date(sll.rule_information2) start_date,

761: cle.start_date fee_start_date,
762: stm.id styId,
763: sll.object1_id1 frequency,
764: TO_NUMBER(sll.rule_information3) periods,
765: FND_DATE.canonical_to_date(sll.rule_information2) start_date,
766: sll.rule_information5 structure,
767: sll.rule_information10 advance_arrears,
768: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
769: TO_NUMBER(sll.rule_information7) stub_days,

Line 795: order by cle.id,stm.id, FND_DATE.canonical_to_date(sll.rule_information2);

791: AND slh.rule_information_category = 'LASLH'
792: AND slh.object1_id1 = TO_CHAR(stm.id)
793: AND TO_CHAR(slh.id) = sll.object2_id1
794: AND sll.rule_information_category = 'LASLL'
795: order by cle.id,stm.id, FND_DATE.canonical_to_date(sll.rule_information2);
796:
797: r_rollover_fee_pmnts c_rollover_fee_pmnts%ROWTYPE;
798:
799: Cursor c_rollover_fee IS

Line 5315: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,

5311: --Added order by cle_id, sty_id, start_date by djanaswa for bug 6007644
5312: CURSOR c_inflows IS
5313: (SELECT rgp.cle_id cle_id,
5314: TO_NUMBER(rul1.object1_id1) sty_id,
5315: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,
5316: TO_NUMBER(rul2.rule_information3) periods,
5317: rul2.object1_id1 frequency,
5318: rul2.rule_information5 structure,
5319: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears,

Line 5347: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,

5343: AND cle.lse_id = lse.id)
5344: UNION
5345: (SELECT TO_NUMBER(NULL) cle_id,
5346: TO_NUMBER(rul1.object1_id1) sty_id,
5347: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,
5348: TO_NUMBER(rul2.rule_information3) periods,
5349: rul2.object1_id1 frequency,
5350: rul2.rule_information5 structure,
5351: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears,

Line 6036: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,

6032: CURSOR c_inflows IS
6033: SELECT rgp.cle_id cle_id,
6034: TO_NUMBER(rul1.object1_id1) sty_id,
6035: sty.stream_type_purpose,
6036: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,
6037: TO_NUMBER(rul2.rule_information3) periods,
6038: rul2.object1_id1 frequency,
6039: rul2.rule_information5 structure,
6040: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears,

Line 6069: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,

6065: UNION
6066: SELECT TO_NUMBER(NULL) cle_id,
6067: TO_NUMBER(rul1.object1_id1) sty_id,
6068: sty.stream_type_purpose,
6069: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,
6070: TO_NUMBER(rul2.rule_information3) periods,
6071: rul2.object1_id1 frequency,
6072: rul2.rule_information5 structure,
6073: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears,

Line 7893: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,

7889:
7890: CURSOR l_varint_sll_csr( khrid NUMBER ) IS
7891: SELECT TO_NUMBER(NULL) cle_id,
7892: TO_NUMBER(rul1.object1_id1) sty_id,
7893: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,
7894: TO_NUMBER(rul2.rule_information3) periods,
7895: rul2.object1_id1 frequency,
7896: rul2.rule_information5 structure,
7897: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears,

Line 11068: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);

11064: AND slh.rule_information_category = 'LASLH'
11065: AND slh.object1_id1 = TO_CHAR(sty.id)
11066: AND TO_CHAR(slh.id) = sll.object2_id1
11067: AND sll.rule_information_category = 'LASLL'
11068: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);
11069:
11070: l_deal_type VARCHAR2(30);
11071:
11072: l_api_name CONSTANT VARCHAR2(61) := 'GET_SCHED_PRINCIPAL_BAL';

Line 11324: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,

11320: --Added order by rul2.rule_information2 by djanaswa for bug 6007644
11321: CURSOR l_varint_sll_csr( khrid NUMBER ) IS
11322: SELECT TO_NUMBER(NULL) cle_id,
11323: TO_NUMBER(rul1.object1_id1) sty_id,
11324: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,
11325: TO_NUMBER(rul2.rule_information3) periods,
11326: rul2.object1_id1 frequency,
11327: rul2.rule_information5 structure,
11328: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears,

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

11342: AND rgp.cle_id IS NULL
11343: AND TO_NUMBER(rul2.object2_id1) = rul1.id
11344: AND TO_NUMBER(rul1.object1_id1) = sty.id
11345: AND sty.stream_type_purpose = 'VARIABLE_INTEREST_SCHEDULE'
11346: ORDER BY FND_DATE.canonical_to_date(rul2.rule_information2);
11347:
11348: l_varint_sll_rec l_varint_sll_csr%ROWTYPE;
11349:
11350: l_advance_or_arrears VARCHAR2(10) := 'ARREARS';

Line 11597: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,

11593: IS
11594: CURSOR c_inflows IS
11595: SELECT rgp.cle_id cle_id,
11596: TO_NUMBER(rul1.object1_id1) sty_id,
11597: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,
11598: TO_NUMBER(rul2.rule_information3) periods,
11599: rul2.object1_id1 frequency,
11600: rul2.rule_information5 structure,
11601: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears,

Line 11827: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,

11823: CURSOR c_inflows IS
11824: SELECT rgp.cle_id cle_id,
11825: TO_NUMBER(rul1.object1_id1) sty_id,
11826: sty.stream_type_purpose,
11827: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,
11828: TO_NUMBER(rul2.rule_information3) periods,
11829: rul2.object1_id1 frequency,
11830: rul2.rule_information5 structure,
11831: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears,