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_ACCRUAL_SEC_PVT dependencies on OKL_POOL_PVT

Line 98: AND opc.status_code IN (Okl_Pool_Pvt.G_POC_STS_ACTIVE, Okl_Pool_Pvt.G_POC_STS_NEW);

94: AND opc.khr_id = khr.id
95: AND opc.sty_id = stytl.id
96: --AND stytl.name = 'RENT'
97: AND stytl.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')
98: AND opc.status_code IN (Okl_Pool_Pvt.G_POC_STS_ACTIVE, Okl_Pool_Pvt.G_POC_STS_NEW);
99: --AND stytl.language = USERENV('LANG');
100:
101: -- cursor to get first kle_id and earliest stream element date
102: CURSOR get_kle_id_csr(p_khr_id NUMBER)

Line 112: AND opc.status_code IN (Okl_Pool_Pvt.G_POC_STS_ACTIVE, Okl_Pool_Pvt.G_POC_STS_NEW)

108: WHERE opc.khr_id = p_khr_id
109: AND opc.sty_id = sty.id
110: --AND sty.code = 'RENT'
111: AND sty.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')
112: AND opc.status_code IN (Okl_Pool_Pvt.G_POC_STS_ACTIVE, Okl_Pool_Pvt.G_POC_STS_NEW)
113: AND ROWNUM < 2
114: GROUP BY opc.kle_id;
115:
116: /* sosharma ,14-12-2007

Line 142: AND opc.status_code = G_PC_STS_PENDING; --Okl_Pool_Pvt.G_POC_STS_PENDING;

138: AND opc.khr_id = khr.id
139: AND opc.sty_id = stytl.id
140: --AND stytl.name = 'RENT'
141: AND stytl.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')
142: AND opc.status_code = G_PC_STS_PENDING; --Okl_Pool_Pvt.G_POC_STS_PENDING;
143: --AND stytl.language = USERENV('LANG');
144:
145: -- cursor to get first kle_id and earliest stream element date
146:

Line 157: AND opc.status_code = G_PC_STS_PENDING --Okl_Pool_Pvt.G_POC_STS_PENDING

153: WHERE opc.khr_id = p_khr_id
154: AND opc.sty_id = sty.id
155: --AND sty.code = 'RENT'
156: AND sty.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')
157: AND opc.status_code = G_PC_STS_PENDING --Okl_Pool_Pvt.G_POC_STS_PENDING
158: AND ROWNUM < 2
159: GROUP BY opc.kle_id;
160:
161: CURSOR get_inv_pend_csr (p_khr_id NUMBER)

Line 172: AND opc.status_code = G_PC_STS_PENDING;--Okl_Pool_Pvt.G_POC_STS_PENDING ;

168: AND opc.khr_id = p_khr_id
169: AND opc.sty_id = sty.id
170: --AND sty.code = 'RENT';
171: AND sty.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')
172: AND opc.status_code = G_PC_STS_PENDING;--Okl_Pool_Pvt.G_POC_STS_PENDING ;
173:
174: /* sosharma end changes*/
175:
176: -- cursor to get advance/arrears and frequency for rent stream type

Line 247: AND opc.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE ; --Added by VARANGAN -Pool Contents Impact(Bug#6658065)

243: AND opc.khr_id = p_khr_id
244: AND opc.sty_id = sty.id
245: --AND sty.code = 'RENT';
246: AND sty.stream_type_purpose = 'RENT'
247: AND opc.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE ; --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
248:
249:
250: l_contracts_csr securitized_contracts_csr%ROWTYPE;
251: CURSOR stream_id_csr (p_khr_id NUMBER,

Line 1455: AND opc.status_code IN (Okl_Pool_Pvt.G_POC_STS_ACTIVE, Okl_Pool_Pvt.G_POC_STS_NEW)

1451: AND opc.khr_id = khr.id
1452: AND opc.sty_id = stytl.id
1453: --AND stytl.code = 'RENT'
1454: AND stytl.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')
1455: AND opc.status_code IN (Okl_Pool_Pvt.G_POC_STS_ACTIVE, Okl_Pool_Pvt.G_POC_STS_NEW)
1456: GROUP BY opc.khr_id, opc.streams_from_date, opc.streams_to_date, khr.deal_type;
1457:
1458: -- cursor to get first kle_id and earliest stream element date
1459: CURSOR get_kle_id_csr(p_khr_id NUMBER)

Line 1469: AND opc.status_code IN (Okl_Pool_Pvt.G_POC_STS_ACTIVE, Okl_Pool_Pvt.G_POC_STS_NEW)

1465: WHERE opc.khr_id = p_khr_id
1466: AND opc.sty_id = sty.id
1467: --AND sty.code = 'RENT'
1468: AND sty.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')
1469: AND opc.status_code IN (Okl_Pool_Pvt.G_POC_STS_ACTIVE, Okl_Pool_Pvt.G_POC_STS_NEW)
1470: AND ROWNUM < 2
1471: GROUP BY opc.kle_id;
1472:
1473: /* sosharma ,14-12-2007

Line 1493: AND opc.status_code = G_PC_STS_PENDING --Okl_Pool_Pvt.G_POC_STS_PENDING

1489: AND opc.khr_id = khr.id
1490: AND opc.sty_id = stytl.id
1491: --AND stytl.code = 'RENT'
1492: AND stytl.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')
1493: AND opc.status_code = G_PC_STS_PENDING --Okl_Pool_Pvt.G_POC_STS_PENDING
1494: GROUP BY opc.khr_id, opc.streams_from_date, opc.streams_to_date, khr.deal_type;
1495:
1496: -- cursor to get first kle_id and earliest stream element date
1497: CURSOR get_kle_id_pend_csr(p_khr_id NUMBER)

Line 1507: AND opc.status_code = G_PC_STS_PENDING --Okl_Pool_Pvt.G_POC_STS_PENDING

1503: WHERE opc.khr_id = p_khr_id
1504: AND opc.sty_id = sty.id
1505: --AND sty.code = 'RENT'
1506: AND sty.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')
1507: AND opc.status_code = G_PC_STS_PENDING --Okl_Pool_Pvt.G_POC_STS_PENDING
1508: AND ROWNUM < 2
1509: GROUP BY opc.kle_id;
1510:
1511: /* sosharma end changes*/

Line 4166: --AND opc.status_code = G_PC_STS_PENDING --Okl_Pool_Pvt.G_POC_STS_PENDING

4162: WHERE opc.khr_id = p_khr_id
4163: AND opc.sty_id = sty.id
4164: --AND sty.code = 'RENT'
4165: AND sty.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')
4166: --AND opc.status_code = G_PC_STS_PENDING --Okl_Pool_Pvt.G_POC_STS_PENDING
4167: AND ROWNUM < 2
4168: GROUP BY opc.kle_id;
4169:
4170: