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_INVESTOR_INVOICE_DISB_PVT dependencies on DUAL

Line 91: FROM dual;

87: -- Cursor to fetch Ap Interface Sequence Number
88: -----------------------------------------------------------------
89: CURSOR seq_csr IS
90: SELECT ap_invoices_interface_s.nextval
91: FROM dual;
92:
93: -----------------------------------------------------------------
94: -- Cursor to fetch Stream Name
95: -----------------------------------------------------------------

Line 177: select add_months(l_next_date, l_mnth_adder) INTO l_next_date from dual;

173: return null;
174: end if;
175: /* -- sechawla 26-Jun-09 8459929 : begin
176: loop
177: select add_months(l_next_date, l_mnth_adder) INTO l_next_date from dual;
178: exit when l_next_date >= p_offset_date;
179: end loop;
180: */
181: l_months_between := months_between(p_offset_date,p_start_date);

Line 1057: -- Bug 13585043 - cheanged the query to get the amount applied to individual

1053: */
1054:
1055: -- sosharma added for bug 9578399
1056: -- vsgandhi Jan-14-20112
1057: -- Bug 13585043 - cheanged the query to get the amount applied to individual
1058: -- contract line when receipt is applied thru AR for consolidated invoices.
1059: CURSOR rcpts_csr ( p_tld_id NUMBER,
1060: p_inv_agr_id NUMBER,
1061: p_inv_agr_line_id NUMBER ) IS

Line 1377: --fmiao for bug 4961860: check whether residual exists

1373: and rul.RULE_INFORMATION_CATEGORY = 'LASEAC'
1374: and rgp.RGD_CODE = 'LASEAC';
1375: -- End Bug 4648410
1376:
1377: --fmiao for bug 4961860: check whether residual exists
1378: CURSOR check_res_in_pool(p_khr_id NUMBER) IS
1379: SELECT 'Y'
1380: FROM dual
1381: WHERE EXISTS

Line 1380: FROM dual

1376:
1377: --fmiao for bug 4961860: check whether residual exists
1378: CURSOR check_res_in_pool(p_khr_id NUMBER) IS
1379: SELECT 'Y'
1380: FROM dual
1381: WHERE EXISTS
1382: ( SELECT 1
1383: FROM OKL_POOLS pool, okl_pool_contents_v poc, okl_strm_type_v sty
1384: WHERE pool.khr_id = p_khr_id

Line 1387: AND sty.stream_type_purpose = 'RESIDUAL_VALUE'

1383: FROM OKL_POOLS pool, okl_pool_contents_v poc, okl_strm_type_v sty
1384: WHERE pool.khr_id = p_khr_id
1385: AND pool.id = poc.pol_id
1386: AND poc.sty_id = sty.id
1387: AND sty.stream_type_purpose = 'RESIDUAL_VALUE'
1388: AND poc.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE); --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
1389:
1390: l_res_in_pool VARCHAR2(1);
1391: l_evrgrn_psthrgh_flg NUMBER := 0;

Line 1598: 'INVESTOR_RESIDUAL_BUYBACK',

1594: 'INVESTOR_RENT_BUYBACK',
1595: 'INVESTOR_PRINCIPAL_BUYBACK',
1596: 'INVESTOR_INTEREST_BUYBACK',
1597: 'INVESTOR_PAYDOWN_BUYBACK',
1598: 'INVESTOR_RESIDUAL_BUYBACK',
1599: 'INVESTOR_EVERGREEN_RENT_PAY',
1600: 'INVESTOR_RESIDUAL_PAY',
1601: 'INVESTOR_CNTRCT_OBLIGATION_PAY',
1602: 'INVESTOR_DISB_ADJUSTMENT')

Line 1600: 'INVESTOR_RESIDUAL_PAY',

1596: 'INVESTOR_INTEREST_BUYBACK',
1597: 'INVESTOR_PAYDOWN_BUYBACK',
1598: 'INVESTOR_RESIDUAL_BUYBACK',
1599: 'INVESTOR_EVERGREEN_RENT_PAY',
1600: 'INVESTOR_RESIDUAL_PAY',
1601: 'INVESTOR_CNTRCT_OBLIGATION_PAY',
1602: 'INVESTOR_DISB_ADJUSTMENT')
1603: THEN
1604: l_sty_id := inv_disb_rec.sty_id;

Line 1793: ELSIF inv_disb_rec.Stream_purpose IN ('INVESTOR_RESIDUAL_DISB_BASIS',

1789: 'INVESTOR_INTEREST_DISB_BASIS',
1790: 'INVESTOR_PPD_DISB_BASIS')
1791: THEN
1792: l_parent_sty_subclass := 'LOAN_PAYMENT';
1793: ELSIF inv_disb_rec.Stream_purpose IN ('INVESTOR_RESIDUAL_DISB_BASIS',
1794: 'INVESTOR_RESIDUAL_BUYBACK',
1795: 'INVESTOR_EVERGREEN_RENT_PAY',
1796: --pgomes fix for bug 4430377
1797: 'INVESTOR_RESIDUAL_PAY')

Line 1794: 'INVESTOR_RESIDUAL_BUYBACK',

1790: 'INVESTOR_PPD_DISB_BASIS')
1791: THEN
1792: l_parent_sty_subclass := 'LOAN_PAYMENT';
1793: ELSIF inv_disb_rec.Stream_purpose IN ('INVESTOR_RESIDUAL_DISB_BASIS',
1794: 'INVESTOR_RESIDUAL_BUYBACK',
1795: 'INVESTOR_EVERGREEN_RENT_PAY',
1796: --pgomes fix for bug 4430377
1797: 'INVESTOR_RESIDUAL_PAY')
1798: THEN

Line 1797: 'INVESTOR_RESIDUAL_PAY')

1793: ELSIF inv_disb_rec.Stream_purpose IN ('INVESTOR_RESIDUAL_DISB_BASIS',
1794: 'INVESTOR_RESIDUAL_BUYBACK',
1795: 'INVESTOR_EVERGREEN_RENT_PAY',
1796: --pgomes fix for bug 4430377
1797: 'INVESTOR_RESIDUAL_PAY')
1798: THEN
1799: l_parent_sty_subclass := 'RESIDUAL';
1800: ELSIF inv_disb_rec.Stream_purpose = 'INVESTOR_LATE_FEE_PAYABLE' THEN
1801: l_parent_sty_subclass := 'LATE_CHARGE';

Line 1799: l_parent_sty_subclass := 'RESIDUAL';

1795: 'INVESTOR_EVERGREEN_RENT_PAY',
1796: --pgomes fix for bug 4430377
1797: 'INVESTOR_RESIDUAL_PAY')
1798: THEN
1799: l_parent_sty_subclass := 'RESIDUAL';
1800: ELSIF inv_disb_rec.Stream_purpose = 'INVESTOR_LATE_FEE_PAYABLE' THEN
1801: l_parent_sty_subclass := 'LATE_CHARGE';
1802: ELSIF inv_disb_rec.Stream_purpose = 'INVESTOR_LATE_INTEREST_PAY' THEN
1803: l_parent_sty_subclass := 'LATE_INTEREST';

Line 1822: -- Residual Subclass to be treated as Billing Based

1818: END IF;
1819:
1820: ----------------------------------------------------
1821: -- Process Based on Billing Or Receipt
1822: -- Residual Subclass to be treated as Billing Based
1823: ----------------------------------------------------
1824: -- -----------------------------------------
1825: -- Bug 4040202 - Treat all cases of missing
1826: -- parent sel_id as a case of billing

Line 1829: (inv_disb_rec.subclass = 'RESIDUAL') OR

1825: -- Bug 4040202 - Treat all cases of missing
1826: -- parent sel_id as a case of billing
1827: -- -----------------------------------------
1828: IF ( (NVL( l_payment_event,'BILLING' ) = 'BILLING') OR
1829: (inv_disb_rec.subclass = 'RESIDUAL') OR
1830: (inv_disb_rec.ref_sel_id IS NULL)
1831: ) THEN
1832: ----------------------------------------------------
1833: -- Billing Based disbursement

Line 2335: (inv_disb_rec.subclass = 'RESIDUAL') OR

2331: FOR i IN tld_succ_log_table.FIRST..tld_succ_log_table.LAST LOOP
2332: --end:| 09-Mar-2007 cklee Change khr_id from header to line |
2333: IF ( NVL( l_payment_event,'BILLING' ) = 'BILLING' ) OR
2334: --pgomes fix for bug 4430377
2335: (inv_disb_rec.subclass = 'RESIDUAL') OR
2336: (inv_disb_rec.ref_sel_id IS NULL) THEN
2337:
2338: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ### 43.1 ### ');
2339: --ssiruvol Bug 5000886 start