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 774: FND_DATE.canonical_to_date(sll.rule_information2) start_date,

770: cle.start_date fee_start_date,
771: stm.id styId,
772: sll.object1_id1 frequency,
773: TO_NUMBER(sll.rule_information3) periods,
774: FND_DATE.canonical_to_date(sll.rule_information2) start_date,
775: sll.rule_information5 structure,
776: sll.rule_information10 advance_arrears,
777: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
778: TO_NUMBER(sll.rule_information7) stub_days,

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

800: AND slh.rule_information_category = 'LASLH'
801: AND slh.object1_id1 = TO_CHAR(stm.id)
802: AND TO_CHAR(slh.id) = sll.object2_id1
803: AND sll.rule_information_category = 'LASLL'
804: order by cle.id,stm.id, FND_DATE.canonical_to_date(sll.rule_information2);
805:
806: r_rollover_fee_pmnts c_rollover_fee_pmnts%ROWTYPE;
807:
808: Cursor c_rollover_fee IS

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

5233: --Added order by cle_id, sty_id, start_date by djanaswa for bug 6007644
5234: CURSOR c_inflows IS
5235: (SELECT rgp.cle_id cle_id,
5236: TO_NUMBER(rul1.object1_id1) sty_id,
5237: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,
5238: TO_NUMBER(rul2.rule_information3) periods,
5239: rul2.object1_id1 frequency,
5240: rul2.rule_information5 structure,
5241: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears,

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

5265: AND cle.lse_id = lse.id)
5266: UNION
5267: (SELECT TO_NUMBER(NULL) cle_id,
5268: TO_NUMBER(rul1.object1_id1) sty_id,
5269: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,
5270: TO_NUMBER(rul2.rule_information3) periods,
5271: rul2.object1_id1 frequency,
5272: rul2.rule_information5 structure,
5273: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears,

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

6980: )
6981: IS
6982: SELECT TO_NUMBER(slh.object1_id1) sty_id,
6983: sty.stream_type_purpose sty_purpose,
6984: FND_DATE.canonical_to_date(sll.rule_information2) start_date,
6985: TO_NUMBER(sll.rule_information3) periods,
6986: sll.object1_id1 frequency,
6987: sll.rule_information5 structure,
6988: DECODE(sll.rule_information10,

Line 6998: ( FND_DATE.canonical_to_date(sll.rule_information2),

6994: DECODE( sll.rule_information7
6995: -- Case: When Payment Level is Regular Periods
6996: ,NULL
6997: ,( ADD_MONTHS
6998: ( FND_DATE.canonical_to_date(sll.rule_information2),
6999: NVL(TO_NUMBER(sll.rule_information3),1)
7000: * DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)
7001: ) - 1
7002: )

Line 7004: ,FND_DATE.canonical_to_date(sll.rule_information2)

7000: * DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)
7001: ) - 1
7002: )
7003: -- Case: When Payment Level is Regular Periods
7004: ,FND_DATE.canonical_to_date(sll.rule_information2)
7005: + TO_NUMBER(sll.rule_information7) - 1
7006: ) end_date
7007: FROM okc_rule_groups_b rgp,
7008: okc_rules_b slh,

Line 7022: ORDER BY sty.id, FND_DATE.canonical_to_date(sll.rule_information2);

7018: ( 'DOWN_PAYMENT'
7019: ,'ESTIMATED_PROPERTY_TAX'
7020: ,'UNSCHEDULED_PRINCIPAL_PAYMENT'
7021: )
7022: ORDER BY sty.id, FND_DATE.canonical_to_date(sll.rule_information2);
7023:
7024: -- Cursor to find the End Date of the Expense Fee
7025: CURSOR get_exp_end_date_csr(
7026: p_khr_id IN NUMBER

Line 8066: FND_DATE.canonical_to_date(cle.start_date) start_date,

8062: -- for the Income Fees
8063: SELECT rgp.cle_id cle_id,
8064: TO_NUMBER(rul1.object1_id1) sty_id,
8065: sty.stream_type_purpose,
8066: FND_DATE.canonical_to_date(cle.start_date) start_date,
8067: NULL periods,
8068: NULL frequency,
8069: NULL structure,
8070: NULL advance_arrears,

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

8100: -- so that ISG uses this information and generate the Accrued Fee Income Streams
8101: SELECT rgp.cle_id cle_id,
8102: TO_NUMBER(rul1.object1_id1) sty_id,
8103: sty.stream_type_purpose,
8104: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,
8105: TO_NUMBER(rul2.rule_information3) periods,
8106: rul2.object1_id1 frequency,
8107: rul2.rule_information5 structure,
8108: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears,

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

8136: UNION
8137: SELECT TO_NUMBER(NULL) cle_id,
8138: TO_NUMBER(rul1.object1_id1) sty_id,
8139: sty.stream_type_purpose,
8140: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,
8141: TO_NUMBER(rul2.rule_information3) periods,
8142: rul2.object1_id1 frequency,
8143: rul2.rule_information5 structure,
8144: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears,

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

10344:
10345: CURSOR l_varint_sll_csr( khrid NUMBER ) IS
10346: SELECT TO_NUMBER(NULL) cle_id,
10347: TO_NUMBER(rul1.object1_id1) sty_id,
10348: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,
10349: TO_NUMBER(rul2.rule_information3) periods,
10350: rul2.object1_id1 frequency,
10351: rul2.rule_information5 structure,
10352: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears,

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

13519: AND slh.rule_information_category = 'LASLH'
13520: AND slh.object1_id1 = TO_CHAR(sty.id)
13521: AND TO_CHAR(slh.id) = sll.object2_id1
13522: AND sll.rule_information_category = 'LASLL'
13523: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);
13524:
13525: l_deal_type VARCHAR2(30);
13526:
13527: l_api_name CONSTANT VARCHAR2(61) := 'GET_SCHED_PRINCIPAL_BAL';

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

13775: --Added order by rul2.rule_information2 by djanaswa for bug 6007644
13776: CURSOR l_varint_sll_csr( khrid NUMBER ) IS
13777: SELECT TO_NUMBER(NULL) cle_id,
13778: TO_NUMBER(rul1.object1_id1) sty_id,
13779: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,
13780: TO_NUMBER(rul2.rule_information3) periods,
13781: rul2.object1_id1 frequency,
13782: rul2.rule_information5 structure,
13783: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears,

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

13797: AND rgp.cle_id IS NULL
13798: AND TO_NUMBER(rul2.object2_id1) = rul1.id
13799: AND TO_NUMBER(rul1.object1_id1) = sty.id
13800: AND sty.stream_type_purpose = 'VARIABLE_INTEREST_SCHEDULE'
13801: ORDER BY FND_DATE.canonical_to_date(rul2.rule_information2);
13802:
13803: l_varint_sll_rec l_varint_sll_csr%ROWTYPE;
13804:
13805: l_advance_or_arrears VARCHAR2(10) := 'ARREARS';

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

14060: IS
14061: CURSOR c_inflows IS
14062: SELECT rgp.cle_id cle_id,
14063: TO_NUMBER(rul1.object1_id1) sty_id,
14064: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,
14065: TO_NUMBER(rul2.rule_information3) periods,
14066: rul2.object1_id1 frequency,
14067: rul2.rule_information5 structure,
14068: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears,

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

14290: CURSOR c_inflows IS
14291: SELECT rgp.cle_id cle_id,
14292: TO_NUMBER(rul1.object1_id1) sty_id,
14293: sty.stream_type_purpose,
14294: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,
14295: TO_NUMBER(rul2.rule_information3) periods,
14296: rul2.object1_id1 frequency,
14297: rul2.rule_information5 structure,
14298: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears,