APPS.OKL_STREAM_GENERATOR_PVT dependencies on FND_NUMBER

Line 777: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,

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,
779: TO_NUMBER(sll.rule_information8) stub_amount
780: FROM okc_k_headers_b chr_so,
781: okc_k_lines_b cle,

Line 5242: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,

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,
5242: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,
5243: TO_NUMBER(rul2.rule_information7) stub_days,
5244: TO_NUMBER(rul2.rule_information8) stub_amount,
5245: lse.lty_code lty_code,
5246: kle.capital_amount capital_amount,

Line 5274: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,

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,
5274: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,
5275: TO_NUMBER(rul2.rule_information7) stub_days,
5276: TO_NUMBER(rul2.rule_information8) stub_amount,
5277: NULL lty_code,
5278: TO_NUMBER(NULL) capital_amount,

Line 5911: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,

5907: CURSOR c_inflows(p_cle_id NUMBER)
5908: IS
5909: SELECT TO_NUMBER(rul1.object1_id1) sty_id,
5910: TO_NUMBER(rul2.rule_information3) periods,
5911: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,
5912: TO_NUMBER(rul2.rule_information7) stub_days,
5913: TO_NUMBER(rul2.rule_information8) stub_amount
5914: FROM okc_rule_groups_b rgp,
5915: okc_rules_b rul1,

Line 6991: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,

6987: sll.rule_information5 structure,
6988: DECODE(sll.rule_information10,
6989: 'Y', 'ARREARS',
6990: 'ADVANCE') advance_arrears,
6991: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
6992: TO_NUMBER(sll.rule_information7) stub_days,
6993: TO_NUMBER(sll.rule_information8) stub_amount,
6994: DECODE( sll.rule_information7
6995: -- Case: When Payment Level is Regular Periods

Line 8034: SELECT FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,

8030:
8031: p_compute_irr VARCHAR2(1) := p_compute_rates;
8032:
8033: CURSOR c_niv (kleId NUMBER) IS
8034: SELECT FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,
8035: TO_NUMBER(rul2.rule_information8) stub_amount
8036: FROM okc_rule_groups_b rgp,
8037: okc_rules_b rul1,
8038: okc_rules_b rul2,

Line 8109: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,

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,
8109: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,
8110: TO_NUMBER(rul2.rule_information7) stub_days,
8111: TO_NUMBER(rul2.rule_information8) stub_amount,
8112: lse.lty_code lty_code,
8113: kle.capital_amount capital_amount,

Line 8145: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,

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,
8145: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,
8146: TO_NUMBER(rul2.rule_information7) stub_days,
8147: TO_NUMBER(rul2.rule_information8) stub_amount,
8148: NULL lty_code,
8149: TO_NUMBER(NULL) capital_amount,

Line 10353: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,

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,
10353: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,
10354: TO_NUMBER(rul2.rule_information7) stub_days,
10355: TO_NUMBER(rul2.rule_information8) stub_amount,
10356: NULL lty_code,
10357: TO_NUMBER(NULL) capital_amount,

Line 13784: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,

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,
13784: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,
13785: TO_NUMBER(rul2.rule_information7) stub_days,
13786: TO_NUMBER(rul2.rule_information8) stub_amount,
13787: NULL lty_code,
13788: TO_NUMBER(NULL) capital_amount,

Line 14069: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,

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,
14069: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,
14070: TO_NUMBER(rul2.rule_information7) stub_days,
14071: TO_NUMBER(rul2.rule_information8) stub_amount,
14072: lse.lty_code lty_code,
14073: kle.capital_amount capital_amount,

Line 14299: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,

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,
14299: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,
14300: TO_NUMBER(rul2.rule_information7) stub_days,
14301: TO_NUMBER(rul2.rule_information8) stub_amount,
14302: lse.lty_code lty_code,
14303: kle.capital_amount capital_amount,