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 171: select add_months(l_next_date, l_mnth_adder) INTO l_next_date from dual;

167: return null;
168: end if;
169:
170: loop
171: select add_months(l_next_date, l_mnth_adder) INTO l_next_date from dual;
172: exit when l_next_date >= p_offset_date;
173: end loop;
174: return l_next_date;
175: EXCEPTION

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

1303: and rul.RULE_INFORMATION_CATEGORY = 'LASEAC'
1304: and rgp.RGD_CODE = 'LASEAC';
1305: -- End Bug 4648410
1306:
1307: --fmiao for bug 4961860: check whether residual exists
1308: CURSOR check_res_in_pool(p_khr_id NUMBER) IS
1309: SELECT 'Y'
1310: FROM dual
1311: WHERE EXISTS

Line 1310: FROM dual

1306:
1307: --fmiao for bug 4961860: check whether residual exists
1308: CURSOR check_res_in_pool(p_khr_id NUMBER) IS
1309: SELECT 'Y'
1310: FROM dual
1311: WHERE EXISTS
1312: ( SELECT 1
1313: FROM OKL_POOLS pool, okl_pool_contents_v poc, okl_strm_type_v sty
1314: WHERE pool.khr_id = p_khr_id

Line 1317: AND sty.stream_type_purpose = 'RESIDUAL_VALUE'

1313: FROM OKL_POOLS pool, okl_pool_contents_v poc, okl_strm_type_v sty
1314: WHERE pool.khr_id = p_khr_id
1315: AND pool.id = poc.pol_id
1316: AND poc.sty_id = sty.id
1317: AND sty.stream_type_purpose = 'RESIDUAL_VALUE'
1318: AND poc.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE); --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
1319:
1320: l_res_in_pool VARCHAR2(1);
1321: l_evrgrn_psthrgh_flg NUMBER := 0;

Line 1528: 'INVESTOR_RESIDUAL_BUYBACK',

1524: 'INVESTOR_RENT_BUYBACK',
1525: 'INVESTOR_PRINCIPAL_BUYBACK',
1526: 'INVESTOR_INTEREST_BUYBACK',
1527: 'INVESTOR_PAYDOWN_BUYBACK',
1528: 'INVESTOR_RESIDUAL_BUYBACK',
1529: 'INVESTOR_EVERGREEN_RENT_PAY',
1530: 'INVESTOR_RESIDUAL_PAY',
1531: 'INVESTOR_CNTRCT_OBLIGATION_PAY',
1532: 'INVESTOR_DISB_ADJUSTMENT')

Line 1530: 'INVESTOR_RESIDUAL_PAY',

1526: 'INVESTOR_INTEREST_BUYBACK',
1527: 'INVESTOR_PAYDOWN_BUYBACK',
1528: 'INVESTOR_RESIDUAL_BUYBACK',
1529: 'INVESTOR_EVERGREEN_RENT_PAY',
1530: 'INVESTOR_RESIDUAL_PAY',
1531: 'INVESTOR_CNTRCT_OBLIGATION_PAY',
1532: 'INVESTOR_DISB_ADJUSTMENT')
1533: THEN
1534: l_sty_id := inv_disb_rec.sty_id;

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

1719: 'INVESTOR_INTEREST_DISB_BASIS',
1720: 'INVESTOR_PPD_DISB_BASIS')
1721: THEN
1722: l_parent_sty_subclass := 'LOAN_PAYMENT';
1723: ELSIF inv_disb_rec.Stream_purpose IN ('INVESTOR_RESIDUAL_DISB_BASIS',
1724: 'INVESTOR_RESIDUAL_BUYBACK',
1725: 'INVESTOR_EVERGREEN_RENT_PAY',
1726: --pgomes fix for bug 4430377
1727: 'INVESTOR_RESIDUAL_PAY')

Line 1724: 'INVESTOR_RESIDUAL_BUYBACK',

1720: 'INVESTOR_PPD_DISB_BASIS')
1721: THEN
1722: l_parent_sty_subclass := 'LOAN_PAYMENT';
1723: ELSIF inv_disb_rec.Stream_purpose IN ('INVESTOR_RESIDUAL_DISB_BASIS',
1724: 'INVESTOR_RESIDUAL_BUYBACK',
1725: 'INVESTOR_EVERGREEN_RENT_PAY',
1726: --pgomes fix for bug 4430377
1727: 'INVESTOR_RESIDUAL_PAY')
1728: THEN

Line 1727: 'INVESTOR_RESIDUAL_PAY')

1723: ELSIF inv_disb_rec.Stream_purpose IN ('INVESTOR_RESIDUAL_DISB_BASIS',
1724: 'INVESTOR_RESIDUAL_BUYBACK',
1725: 'INVESTOR_EVERGREEN_RENT_PAY',
1726: --pgomes fix for bug 4430377
1727: 'INVESTOR_RESIDUAL_PAY')
1728: THEN
1729: l_parent_sty_subclass := 'RESIDUAL';
1730: ELSIF inv_disb_rec.Stream_purpose = 'INVESTOR_LATE_FEE_PAYABLE' THEN
1731: l_parent_sty_subclass := 'LATE_CHARGE';

Line 1729: l_parent_sty_subclass := 'RESIDUAL';

1725: 'INVESTOR_EVERGREEN_RENT_PAY',
1726: --pgomes fix for bug 4430377
1727: 'INVESTOR_RESIDUAL_PAY')
1728: THEN
1729: l_parent_sty_subclass := 'RESIDUAL';
1730: ELSIF inv_disb_rec.Stream_purpose = 'INVESTOR_LATE_FEE_PAYABLE' THEN
1731: l_parent_sty_subclass := 'LATE_CHARGE';
1732: ELSIF inv_disb_rec.Stream_purpose = 'INVESTOR_LATE_INTEREST_PAY' THEN
1733: l_parent_sty_subclass := 'LATE_INTEREST';

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

1748: END IF;
1749:
1750: ----------------------------------------------------
1751: -- Process Based on Billing Or Receipt
1752: -- Residual Subclass to be treated as Billing Based
1753: ----------------------------------------------------
1754: -- -----------------------------------------
1755: -- Bug 4040202 - Treat all cases of missing
1756: -- parent sel_id as a case of billing

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

1755: -- Bug 4040202 - Treat all cases of missing
1756: -- parent sel_id as a case of billing
1757: -- -----------------------------------------
1758: IF ( (NVL( l_payment_event,'BILLING' ) = 'BILLING') OR
1759: (inv_disb_rec.subclass = 'RESIDUAL') OR
1760: (inv_disb_rec.ref_sel_id IS NULL)
1761: ) THEN
1762: ----------------------------------------------------
1763: -- Billing Based disbursement

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

2243: FOR i IN tld_succ_log_table.FIRST..tld_succ_log_table.LAST LOOP
2244: --end:| 09-Mar-2007 cklee Change khr_id from header to line |
2245: IF ( NVL( l_payment_event,'BILLING' ) = 'BILLING' ) OR
2246: --pgomes fix for bug 4430377
2247: (inv_disb_rec.subclass = 'RESIDUAL') OR
2248: (inv_disb_rec.ref_sel_id IS NULL) THEN
2249:
2250: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ### 43.1 ### ');
2251: --ssiruvol Bug 5000886 start