APPS.OKL_ACCRUAL_SEC_PVT dependencies on OKL_POOL_PVT

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

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

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

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

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

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

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

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

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

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

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

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

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

986: AND opc.khr_id = khr.id
987: AND opc.sty_id = stytl.id
988: --AND stytl.code = 'RENT'
989: AND stytl.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')
990: AND opc.status_code IN (Okl_Pool_Pvt.G_POC_STS_ACTIVE, Okl_Pool_Pvt.G_POC_STS_NEW)
991: GROUP BY opc.khr_id, opc.streams_from_date, opc.streams_to_date, khr.deal_type;
992:
993: -- cursor to get first kle_id and earliest stream element date
994: CURSOR get_kle_id_csr(p_khr_id NUMBER)

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

1000: WHERE opc.khr_id = p_khr_id
1001: AND opc.sty_id = sty.id
1002: --AND sty.code = 'RENT'
1003: AND sty.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')
1004: AND opc.status_code IN (Okl_Pool_Pvt.G_POC_STS_ACTIVE, Okl_Pool_Pvt.G_POC_STS_NEW)
1005: AND ROWNUM < 2
1006: GROUP BY opc.kle_id;
1007:
1008: /* sosharma ,14-12-2007

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

1024: AND opc.khr_id = khr.id
1025: AND opc.sty_id = stytl.id
1026: --AND stytl.code = 'RENT'
1027: AND stytl.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')
1028: AND opc.status_code = G_PC_STS_PENDING --Okl_Pool_Pvt.G_POC_STS_PENDING
1029: GROUP BY opc.khr_id, opc.streams_from_date, opc.streams_to_date, khr.deal_type;
1030:
1031: -- cursor to get first kle_id and earliest stream element date
1032: CURSOR get_kle_id_pend_csr(p_khr_id NUMBER)

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

1038: WHERE opc.khr_id = p_khr_id
1039: AND opc.sty_id = sty.id
1040: --AND sty.code = 'RENT'
1041: AND sty.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')
1042: AND opc.status_code = G_PC_STS_PENDING --Okl_Pool_Pvt.G_POC_STS_PENDING
1043: AND ROWNUM < 2
1044: GROUP BY opc.kle_id;
1045:
1046: /* sosharma end changes*/