DBA Data[Home] [Help]

APPS.OKL_PRICING_PVT dependencies on FND_NUMBER

Line 176: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount

172: TO_NUMBER(SLL.rule_information3) periods,
173: DECODE(sll.object1_id1, 'M', 30, 'Q', 120, 'S', 180, 'A', 360) dpp,
174: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
175: NVL(sll.rule_information10, 'N') arrears_yn,
176: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount
177: FROM okc_rules_b sll,
178: okc_rules_b slh,
179: okc_rule_groups_b rgp,
180: okl_strm_type_b sty,

Line 1263: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount

1259: TO_NUMBER(SLL.rule_information3) periods,
1260: DECODE(sll.object1_id1, 'M', 30, 'Q', 120, 'S', 180, 'A', 360) dpp,
1261: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
1262: NVL(sll.rule_information10, 'N') arrears_yn,
1263: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount
1264: FROM okc_rules_b sll,
1265: okc_rules_b slh,
1266: okc_rule_groups_b rgp,
1267: okl_strm_type_b sty,

Line 6233: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount

6229: TO_NUMBER(SLL.rule_information3) periods,
6230: DECODE(sll.object1_id1, 'M', 30, 'Q', 120, 'S', 180, 'A', 360) dpp,
6231: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
6232: NVL(sll.rule_information10, 'N') arrears_yn,
6233: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount
6234: FROM okc_rules_b sll,
6235: okc_rules_b slh,
6236: okc_rule_groups_b rgp,
6237: okl_strm_type_b sty

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

7534: TO_NUMBER(sll.rule_information3) periods,
7535: FND_DATE.canonical_to_date(sll.rule_information2) start_date,
7536: sll.rule_information5 structure,
7537: sll.rule_information10 advance_arrears,
7538: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
7539: TO_NUMBER(sll.rule_information7) stub_days,
7540: TO_NUMBER(sll.rule_information8) stub_amount
7541: FROM okc_k_headers_b chr_so,
7542: okc_k_lines_b cle,

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

10036: TO_NUMBER(sll.rule_information3) periods,
10037: FND_DATE.canonical_to_date(sll.rule_information2) start_date,
10038: sll.rule_information5 structure,
10039: sll.rule_information10 advance_arrears,
10040: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
10041: TO_NUMBER(sll.rule_information7) stub_days,
10042: TO_NUMBER(sll.rule_information8) stub_amount
10043: FROM okc_k_headers_b chr_so,
10044: okc_k_lines_b cle,

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

10075: TO_NUMBER(sll.rule_information3) periods,
10076: FND_DATE.canonical_to_date(sll.rule_information2) start_date,
10077: sll.rule_information5 structure,
10078: sll.rule_information10 advance_arrears,
10079: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
10080: TO_NUMBER(sll.rule_information7) stub_days,
10081: TO_NUMBER(sll.rule_information8) stub_amount
10082: FROM okc_k_headers_b chr_so,
10083: okc_k_lines_b cle,

Line 11144: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount

11140: TO_NUMBER(SLL.rule_information3) periods,
11141: DECODE(sll.object1_id1, 'M', 30, 'Q', 120, 'S', 180, 'A', 360) dpp,
11142: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
11143: NVL(sll.rule_information10, 'N') arrears_yn,
11144: FND_NUMBER.canonical_to_number(sll.rule_information6) rent_amount
11145: FROM okc_rules_b sll,
11146: okc_rules_b slh,
11147: okc_rule_groups_b rgp,
11148: okl_strm_type_b sty,