APPS.OKL_SEC_AGREEMENT_PVT dependencies on OKL_POOL_CONTENTS

Line 2486: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;

2482: l_org_id OKL_POOLS.ORG_ID%TYPE;
2483: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
2484: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
2485:
2486: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;
2487: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;
2488: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2489: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2490: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 2487: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;

2483: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
2484: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
2485:
2486: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;
2487: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;
2488: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2489: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2490: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2491: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

Line 2519: FROM okl_pool_contents poc

2515: ;
2516:
2517: CURSOR c_poc IS
2518: SELECT poc.id
2519: FROM okl_pool_contents poc
2520: WHERE poc.pol_id = l_pol_id
2521: ;
2522:
2523: -- mvasudev, Fixed bug#3987171

Line 2527: FROM apps.okl_pool_contents poc

2523: -- mvasudev, Fixed bug#3987171
2524: /*
2525: CURSOR c_pool_chr IS
2526: SELECT poc.khr_id
2527: FROM apps.okl_pool_contents poc
2528: WHERE poc.pol_id = l_pol_id
2529: ;
2530: */
2531: CURSOR c_pool_chr IS

Line 2533: FROM okl_pool_contents poc

2529: ;
2530: */
2531: CURSOR c_pool_chr IS
2532: SELECT poc.khr_id
2533: FROM okl_pool_contents poc
2534: WHERE poc.pol_id = l_pol_id
2535: ;
2536:
2537: /* ankushar Bug# 6773285 Added Principal Payment for Loan contracts also renamed Cursor

Line 2546: ,okl_pool_contents pocb

2542: CURSOR l_okl_sty_csr IS
2543: SELECT 1
2544: FROM okl_pools polb
2545: ,okl_strm_type_b styb
2546: ,okl_pool_contents pocb
2547: WHERE polb.khr_id = p_khr_id
2548: AND pocb.pol_id = polb.id
2549: AND pocb.sty_id = styb.id
2550: AND styb.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')

Line 3424: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;

3420: l_org_id OKL_POOLS.ORG_ID%TYPE;
3421: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
3422: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
3423:
3424: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;
3425: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;
3426: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3427:
3428: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 3425: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;

3421: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
3422: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
3423:
3424: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;
3425: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;
3426: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3427:
3428: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3429: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 3457: FROM okl_pool_contents poc

3453: CURSOR c_pool_chr_csr(p_pol_id NUMBER)
3454: IS
3455: SELECT poc.khr_id,
3456: poc.id
3457: FROM okl_pool_contents poc
3458: WHERE poc.pol_id = p_pol_id
3459: AND poc.status_code = Okl_Pool_Pvt.G_POC_STS_PENDING;
3460:
3461: /* ankushar Bug# 6773285 Added Principal Payment for Loan contracts also renamed Cursor

Line 3471: ,okl_pool_contents pocb

3467: IS
3468: SELECT 1
3469: FROM okl_pools polb
3470: ,okl_strm_type_b styb
3471: ,okl_pool_contents pocb
3472: WHERE polb.khr_id = p_khr_id
3473: AND pocb.pol_id = polb.id
3474: AND pocb.sty_id = styb.id
3475: AND styb.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')

Line 4262: FROM OKL_POOL_CONTENTS

4258:
4259: CURSOR get_pol_contents_csr(p_pox_id NUMBER)
4260: IS
4261: SELECT ID
4262: FROM OKL_POOL_CONTENTS
4263: WHERE pox_id = p_pox_id
4264: AND STATUS_CODE <> 'ACTIVE';
4265:
4266: