APPS.OKL_AM_TERMINATE_INV_AGMT_PVT dependencies on OKC_K_HEADERS_B

Line 460: OKC_K_HEADERS_B KHR,

456: CHR.sts_code,
457: CHR.date_terminated
458: FROM OKL_POOLS POL,
459: OKL_POOL_CONTENTS POC,
460: OKC_K_HEADERS_B KHR,
461: OKC_K_HEADERS_B CHR
462: WHERE KHR.id = p_ia_id
463: AND KHR.id = POL.khr_id
464: AND POL.id = POC.pol_id

Line 461: OKC_K_HEADERS_B CHR

457: CHR.date_terminated
458: FROM OKL_POOLS POL,
459: OKL_POOL_CONTENTS POC,
460: OKC_K_HEADERS_B KHR,
461: OKC_K_HEADERS_B CHR
462: WHERE KHR.id = p_ia_id
463: AND KHR.id = POL.khr_id
464: AND POL.id = POC.pol_id
465: AND POL.status_code = 'ACTIVE' -- Pool status

Line 546: OKC_K_HEADERS_B CHR

542: FROM DUAL WHERE EXISTS (
543: SELECT POC.id
544: FROM OKL_POOLS POL,
545: OKL_POOL_CONTENTS POC,
546: OKC_K_HEADERS_B CHR
547: WHERE CHR.id = p_ia_id
548: AND CHR.id = POL.khr_id
549: AND POL.id = POC.pol_id
550: AND NVL(POC.streams_to_date, CHR.end_date+1) > CHR.end_date

Line 565: OKC_K_HEADERS_B CHR

561: OKL_STRM_ELEMENTS SEL,
562: OKL_STRM_TYPE_B STY,
563: OKL_POOLS POL,
564: OKL_POOL_CONTENTS POC,
565: OKC_K_HEADERS_B CHR
566: WHERE CHR.id = p_ia_id
567: AND CHR.id = POL.khr_id
568: AND POL.id = POC.pol_id
569: AND POL.status_code = 'ACTIVE'

Line 718: OKC_K_HEADERS_B KHR

714: OKL_STRM_ELEMENTS SEL,
715: OKL_STRM_TYPE_B STY,
716: OKL_POOLS POL,
717: OKL_POOL_CONTENTS POC,
718: OKC_K_HEADERS_B KHR
719: WHERE KHR.id = p_ia_id
720: AND KHR.id = POL.khr_id
721: AND POL.id = POC.pol_id
722: AND POL.status_code = 'ACTIVE'

Line 1133: FROM OKC_K_HEADERS_B CHR,

1129: CHR.scs_code, -- should be INVESTOR
1130: KHR.pdt_id,
1131: POL.id pool_id,
1132: POL.pool_number
1133: FROM OKC_K_HEADERS_B CHR,
1134: OKL_K_HEADERS KHR,
1135: OKL_POOLS POL
1136: WHERE CHR.id = p_ia_id
1137: AND CHR.id = KHR.id

Line 1238: FROM OKC_K_HEADERS_B CHR,

1234: CURSOR get_ia_lines_csr (p_ia_id IN NUMBER) IS
1235: SELECT CLE.id,
1236: CLE.name,
1237: CLE.sts_code
1238: FROM OKC_K_HEADERS_B CHR,
1239: OKC_K_LINES_V CLE
1240: WHERE CHR.id = p_ia_id
1241: AND CHR.id = CLE.dnz_chr_id
1242: AND CLE.sts_code = CHR.sts_code;

Line 2237: OKC_K_HEADERS_B KHR

2233: -- get the active pools for the IA
2234: CURSOR get_pools_csr(p_ia_id IN NUMBER) IS
2235: SELECT POL.id
2236: FROM OKL_POOLS POL,
2237: OKC_K_HEADERS_B KHR
2238: WHERE KHR.id = p_ia_id
2239: AND KHR.id = POL.khr_id
2240: AND POL.status_code = 'ACTIVE'; -- ACTIVE
2241:

Line 2806: FROM OKC_K_HEADERS_B CHR

2802:
2803: -- Get the latest IA Status
2804: CURSOR ia_status_csr (p_ia_id IN NUMBER) IS
2805: SELECT CHR.sts_code status
2806: FROM OKC_K_HEADERS_B CHR
2807: WHERE CHR.id = p_ia_id;
2808:
2809: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
2810: l_overall_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 3167: FROM OKC_K_HEADERS_B CHR

3163: -- Get the IAs which have reached their end_date and still active and no processed trn exists
3164: CURSOR get_expired_ia_csr (p_date IN DATE) IS
3165: SELECT CHR.id,
3166: CHR.contract_number
3167: FROM OKC_K_HEADERS_B CHR
3168: WHERE CHR.scs_code = 'INVESTOR' -- IA
3169: AND CHR.sts_code = 'ACTIVE' -- ACTIVE
3170: AND CHR.date_terminated IS NULL -- Not Terminated
3171: AND CHR.end_date <= TRUNC(p_date) -- Ended -- RMUNJULU 115.4 3061748 Changed to pick equal dates