APPS.OKL_SEC_AGREEMENT_PVT dependencies on OKL_POOL_CONTENTS

Line 2503: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;

2499: l_org_id OKL_POOLS.ORG_ID%TYPE;
2500: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
2501: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
2502:
2503: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;
2504: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;
2505: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2506: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2507: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 2504: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;

2500: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
2501: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
2502:
2503: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;
2504: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;
2505: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2506: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2507: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
2508: lp_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;

Line 2536: FROM okl_pool_contents poc

2532: ;
2533:
2534: CURSOR c_poc IS
2535: SELECT poc.id
2536: FROM okl_pool_contents poc
2537: WHERE poc.pol_id = l_pol_id
2538: ;
2539:
2540: -- mvasudev, Fixed bug#3987171

Line 2544: FROM apps.okl_pool_contents poc

2540: -- mvasudev, Fixed bug#3987171
2541: /*
2542: CURSOR c_pool_chr IS
2543: SELECT poc.khr_id
2544: FROM apps.okl_pool_contents poc
2545: WHERE poc.pol_id = l_pol_id
2546: ;
2547: */
2548: CURSOR c_pool_chr IS

Line 2550: FROM okl_pool_contents poc

2546: ;
2547: */
2548: CURSOR c_pool_chr IS
2549: SELECT poc.khr_id
2550: FROM okl_pool_contents poc
2551: WHERE poc.pol_id = l_pol_id
2552: ;
2553:
2554: /* ankushar Bug# 6773285 Added Principal Payment for Loan contracts also renamed Cursor

Line 2563: ,okl_pool_contents pocb

2559: CURSOR l_okl_sty_csr IS
2560: SELECT 1
2561: FROM okl_pools polb
2562: ,okl_strm_type_b styb
2563: ,okl_pool_contents pocb
2564: WHERE polb.khr_id = p_khr_id
2565: AND pocb.pol_id = polb.id
2566: AND pocb.sty_id = styb.id
2567: AND styb.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')

Line 3441: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;

3437: l_org_id OKL_POOLS.ORG_ID%TYPE;
3438: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
3439: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
3440:
3441: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;
3442: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;
3443: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3444:
3445: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 3442: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;

3438: l_legal_entity_id OKL_POOLS.LEGAL_ENTITY_ID%TYPE;
3439: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
3440:
3441: l_pox_id OKL_POOL_CONTENTS.POX_ID%TYPE;
3442: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;
3443: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3444:
3445: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3446: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 3474: FROM okl_pool_contents poc

3470: CURSOR c_pool_chr_csr(p_pol_id NUMBER)
3471: IS
3472: SELECT poc.khr_id,
3473: poc.id
3474: FROM okl_pool_contents poc
3475: WHERE poc.pol_id = p_pol_id
3476: AND poc.status_code = Okl_Pool_Pvt.G_POC_STS_PENDING;
3477:
3478: /* ankushar Bug# 6773285 Added Principal Payment for Loan contracts also renamed Cursor

Line 3488: ,okl_pool_contents pocb

3484: IS
3485: SELECT 1
3486: FROM okl_pools polb
3487: ,okl_strm_type_b styb
3488: ,okl_pool_contents pocb
3489: WHERE polb.khr_id = p_khr_id
3490: AND pocb.pol_id = polb.id
3491: AND pocb.sty_id = styb.id
3492: AND styb.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')

Line 4290: FROM OKL_POOL_CONTENTS

4286:
4287: CURSOR get_pol_contents_csr(p_pox_id NUMBER)
4288: IS
4289: SELECT ID
4290: FROM OKL_POOL_CONTENTS
4291: WHERE pox_id = p_pox_id
4292: AND STATUS_CODE <> 'ACTIVE';
4293:
4294: