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_PRICING_PVT dependencies on FND_DATE

Line 171: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,

167:
168: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'get_quote_amortization';
169:
170: CURSOR c_rent_slls ( streamName VARCHAR2 ) IS
171: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
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,

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

190: AND STYT.LANGUAGE = USERENV('LANG') -- Bug 4626837
191: AND styt.name = streamName
192: AND TO_CHAR(slh.id) = sll.object2_id1
193: AND sll.rule_information_category = 'LASLL'
194: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);
195:
196: l_rent_sll c_rent_slls%ROWTYPE;
197:
198: -- bug 2992184. Added where condition for multi-gaap reporting streams.

Line 236: SELECT TRUNC(FND_DATE.canonical_to_date(crl.rule_information2))

232: CURSOR c_date_pay_stub(p_khr_id NUMBER,
233: p_kle_id NUMBER,
234: p_date date)
235: IS
236: SELECT TRUNC(FND_DATE.canonical_to_date(crl.rule_information2))
237: FROM okc_rule_groups_b crg,
238: okc_rules_b crl
239: WHERE crl.rgp_id = crg.id
240: AND crg.rgd_code = 'LALEVL'

Line 244: AND TRUNC(FND_DATE.canonical_to_date(crl.rule_information2)) > TRUNC(p_date)

240: AND crg.rgd_code = 'LALEVL'
241: AND crl.rule_information_category = 'LASLL'
242: AND crg.dnz_chr_id = p_khr_id
243: AND crg.cle_id = p_kle_id
244: AND TRUNC(FND_DATE.canonical_to_date(crl.rule_information2)) > TRUNC(p_date)
245: AND crl.rule_information2 IS NOT NULL
246: AND crl.rule_information6 IS NOT NULL
247: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2);
248:

Line 247: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2);

243: AND crg.cle_id = p_kle_id
244: AND TRUNC(FND_DATE.canonical_to_date(crl.rule_information2)) > TRUNC(p_date)
245: AND crl.rule_information2 IS NOT NULL
246: AND crl.rule_information6 IS NOT NULL
247: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2);
248:
249: l_stub_id NUMBER;
250:
251: TYPE loan_rec IS RECORD (

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

331: AND sty.id = styt.id
332: AND STYT.LANGUAGE = USERENV('LANG') -- Bug 4626837
333: AND TO_CHAR(slh.id) = sll.object2_id1
334: AND sll.rule_information_category = 'LASLL'
335: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);
336:
337: l_was_a_stub_payment VARCHAR2(1) := 'N';
338:
339: l_day_convention_month VARCHAR2(30);

Line 1265: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,

1261:
1262: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'get_loan_amortization';
1263:
1264: CURSOR c_rent_slls ( streamName VARCHAR2 ) IS
1265: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
1266: TO_NUMBER(SLL.rule_information3) periods,
1267: DECODE(sll.object1_id1, 'M', 30, 'Q', 120, 'S', 180, 'A', 360) dpp,
1268: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
1269: NVL(sll.rule_information10, 'N') arrears_yn,

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

1284: AND STYT.LANGUAGE = USERENV('LANG') -- Bug 4626837
1285: AND styt.name = streamName
1286: AND TO_CHAR(slh.id) = sll.object2_id1
1287: AND sll.rule_information_category = 'LASLL'
1288: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);
1289:
1290: l_rent_sll c_rent_slls%ROWTYPE;
1291:
1292: -- bug 2992184. Added where condition for multi-gaap reporting streams.

Line 1344: SELECT TRUNC(FND_DATE.canonical_to_date(crl.rule_information2))

1340: CURSOR c_date_pay_stub(p_khr_id NUMBER,
1341: p_kle_id NUMBER,
1342: p_date date)
1343: IS
1344: SELECT TRUNC(FND_DATE.canonical_to_date(crl.rule_information2))
1345: FROM okc_rule_groups_b crg,
1346: okc_rules_b crl
1347: WHERE crl.rgp_id = crg.id
1348: AND crg.rgd_code = 'LALEVL'

Line 1352: AND TRUNC(FND_DATE.canonical_to_date(crl.rule_information2)) > TRUNC(p_date)

1348: AND crg.rgd_code = 'LALEVL'
1349: AND crl.rule_information_category = 'LASLL'
1350: AND crg.dnz_chr_id = p_khr_id
1351: AND crg.cle_id = p_kle_id
1352: AND TRUNC(FND_DATE.canonical_to_date(crl.rule_information2)) > TRUNC(p_date)
1353: AND crl.rule_information2 IS NOT NULL
1354: AND crl.rule_information6 IS NOT NULL
1355: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2);
1356:

Line 1355: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2);

1351: AND crg.cle_id = p_kle_id
1352: AND TRUNC(FND_DATE.canonical_to_date(crl.rule_information2)) > TRUNC(p_date)
1353: AND crl.rule_information2 IS NOT NULL
1354: AND crl.rule_information6 IS NOT NULL
1355: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2);
1356:
1357: l_stub_id NUMBER;
1358:
1359: TYPE loan_rec IS RECORD (se_amount NUMBER,

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

1457: AND sty.id = styt.id
1458: AND STYT.LANGUAGE = USERENV('LANG') -- Bug 4626837
1459: AND TO_CHAR(slh.id) = sll.object2_id1
1460: AND sll.rule_information_category = 'LASLL'
1461: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);
1462:
1463: CURSOR l_terminated_line_csr is
1464: SELECT kle.ID,
1465: sts.STE_CODE,

Line 2318: SELECT trunc(FND_DATE.canonical_to_date(rul_sll.rule_information2)) start_date,

2314: CURSOR c_rent_slls(p_khr_id okc_k_headers_b.id%TYPE,
2315: p_Kle_id okc_k_lines_b.id%TYPE,
2316: p_line_type VARCHAR2)
2317: IS
2318: SELECT trunc(FND_DATE.canonical_to_date(rul_sll.rule_information2)) start_date,
2319: NVL(rul_sll.rule_information10, 'Y') arrears_yn,
2320: khr_so.term_duration
2321: FROM okc_k_headers_b chr_so,
2322: okl_k_headers khr_so,

Line 4339: SELECT FND_DATE.canonical_to_date(rule_information5)

4335: AND slh.object1_id1 = TO_CHAR(styt.id)
4336: AND styt.stream_type_purpose = 'RENT';
4337:
4338: CURSOR c_deposit_date IS
4339: SELECT FND_DATE.canonical_to_date(rule_information5)
4340: FROM okc_rules_b
4341: WHERE dnz_chr_id = p_khr_id
4342: AND rule_information_category = 'LASDEP';
4343:

Line 5838: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,

5834:
5835: l_hdr c_hdr%ROWTYPE;
5836:
5837: CURSOR c_rent_slls IS
5838: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
5839: TO_NUMBER(SLL.rule_information3) periods,
5840: DECODE(sll.object1_id1, 'M', 30, 'Q', 120, 'S', 180, 'A', 360) dpp,
5841: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
5842: NVL(sll.rule_information10, 'N') arrears_yn,

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

5854: AND sty.version = '1.0'
5855: AND sty.stream_type_purpose = 'RENT'
5856: AND TO_CHAR(slh.id) = sll.object2_id1
5857: AND sll.rule_information_category = 'LASLL'
5858: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);
5859:
5860: l_rent_sll c_rent_slls%ROWTYPE;
5861:
5862: -- bug 2992184. Added where condition for multi-gaap reporting streams.

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

7141: cle.id kleId,
7142: stm.id styId,
7143: sll.object1_id1 frequency,
7144: TO_NUMBER(sll.rule_information3) periods,
7145: FND_DATE.canonical_to_date(sll.rule_information2) start_date,
7146: sll.rule_information5 structure,
7147: sll.rule_information10 advance_arrears,
7148: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
7149: TO_NUMBER(sll.rule_information7) stub_days,

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

7170: AND slh.rule_information_category = 'LASLH'
7171: AND TO_NUMBER(slh.object1_id1) = stm.id
7172: AND TO_CHAR(slh.id) = sll.object2_id1
7173: AND sll.rule_information_category = 'LASLL'
7174: order by stm.id, FND_DATE.canonical_to_date(sll.rule_information2);
7175:
7176: r_fee c_fee%ROWTYPE;
7177: i BINARY_INTEGER;
7178: j BINARY_INTEGER;

Line 8320: SELECT FND_DATE.canonical_to_date(rule_information5)

8316: AND slh.object1_id1 = TO_CHAR(sty.id)
8317: AND sty.stream_type_purpose = 'RENT';
8318:
8319: CURSOR c_deposit_date IS
8320: SELECT FND_DATE.canonical_to_date(rule_information5)
8321: FROM okc_rules_b
8322: WHERE dnz_chr_id = p_khr_id
8323: AND rule_information_category = 'LASDEP';
8324:

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

9648: cle.id kleId,
9649: stm.id styId,
9650: sll.object1_id1 frequency,
9651: TO_NUMBER(sll.rule_information3) periods,
9652: FND_DATE.canonical_to_date(sll.rule_information2) start_date,
9653: sll.rule_information5 structure,
9654: sll.rule_information10 advance_arrears,
9655: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
9656: TO_NUMBER(sll.rule_information7) stub_days,

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

9687: cle.id kleId,
9688: stm.id styId,
9689: sll.object1_id1 frequency,
9690: TO_NUMBER(sll.rule_information3) periods,
9691: FND_DATE.canonical_to_date(sll.rule_information2) start_date,
9692: sll.rule_information5 structure,
9693: sll.rule_information10 advance_arrears,
9694: FND_NUMBER.canonical_to_number(sll.rule_information6) amount,
9695: TO_NUMBER(sll.rule_information7) stub_days,

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

9716: AND slh.rule_information_category = 'LASLH'
9717: AND slh.object1_id1 = TO_CHAR(stm.id)
9718: AND TO_CHAR(slh.id) = sll.object2_id1
9719: AND sll.rule_information_category = 'LASLL'
9720: order by stm.id, FND_DATE.canonical_to_date(sll.rule_information2);
9721:
9722: r_fee c_fee%ROWTYPE;
9723: i BINARY_INTEGER;
9724: j BINARY_INTEGER;

Line 10761: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,

10757:
10758:
10759: -- cursor to get the start date and arrears flag
10760: CURSOR c_rent_slls IS
10761: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
10762: TO_NUMBER(SLL.rule_information3) periods,
10763: DECODE(sll.object1_id1, 'M', 30, 'Q', 120, 'S', 180, 'A', 360) dpp,
10764: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
10765: NVL(sll.rule_information10, 'N') arrears_yn,

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

10778: AND sty.id = styt.id
10779: AND STYT.LANGUAGE = USERENV('LANG')
10780: AND TO_CHAR(slh.id) = sll.object2_id1
10781: AND sll.rule_information_category = 'LASLL'
10782: ORDER BY fnd_date.canonical_to_date(sll.rule_information2);
10783:
10784: l_rent_sll c_rent_slls%ROWTYPE;
10785:
10786: -- cursor to get the payment streams