APPS.OKL_AM_TERMINATE_INV_AGMT_PVT dependencies on OKC_K_HEADERS_B

Line 438: OKC_K_HEADERS_B KHR,

434: CHR.sts_code,
435: CHR.date_terminated
436: FROM OKL_POOLS POL,
437: OKL_POOL_CONTENTS POC,
438: OKC_K_HEADERS_B KHR,
439: OKC_K_HEADERS_B CHR
440: WHERE KHR.id = p_ia_id
441: AND KHR.id = POL.khr_id
442: AND POL.id = POC.pol_id

Line 439: OKC_K_HEADERS_B CHR

435: CHR.date_terminated
436: FROM OKL_POOLS POL,
437: OKL_POOL_CONTENTS POC,
438: OKC_K_HEADERS_B KHR,
439: OKC_K_HEADERS_B CHR
440: WHERE KHR.id = p_ia_id
441: AND KHR.id = POL.khr_id
442: AND POL.id = POC.pol_id
443: AND POL.status_code = 'ACTIVE' -- Pool status

Line 524: OKC_K_HEADERS_B CHR

520: FROM DUAL WHERE EXISTS (
521: SELECT POC.id
522: FROM OKL_POOLS POL,
523: OKL_POOL_CONTENTS POC,
524: OKC_K_HEADERS_B CHR
525: WHERE CHR.id = p_ia_id
526: AND CHR.id = POL.khr_id
527: AND POL.id = POC.pol_id
528: AND NVL(POC.streams_to_date, CHR.end_date+1) > CHR.end_date

Line 543: OKC_K_HEADERS_B CHR

539: OKL_STRM_ELEMENTS SEL,
540: OKL_STRM_TYPE_B STY,
541: OKL_POOLS POL,
542: OKL_POOL_CONTENTS POC,
543: OKC_K_HEADERS_B CHR
544: WHERE CHR.id = p_ia_id
545: AND CHR.id = POL.khr_id
546: AND POL.id = POC.pol_id
547: AND POL.status_code = 'ACTIVE'

Line 696: OKC_K_HEADERS_B KHR

692: OKL_STRM_ELEMENTS SEL,
693: OKL_STRM_TYPE_B STY,
694: OKL_POOLS POL,
695: OKL_POOL_CONTENTS POC,
696: OKC_K_HEADERS_B KHR
697: WHERE KHR.id = p_ia_id
698: AND KHR.id = POL.khr_id
699: AND POL.id = POC.pol_id
700: AND POL.status_code = 'ACTIVE'

Line 1111: FROM OKC_K_HEADERS_B CHR,

1107: CHR.scs_code, -- should be INVESTOR
1108: KHR.pdt_id,
1109: POL.id pool_id,
1110: POL.pool_number
1111: FROM OKC_K_HEADERS_B CHR,
1112: OKL_K_HEADERS KHR,
1113: OKL_POOLS POL
1114: WHERE CHR.id = p_ia_id
1115: AND CHR.id = KHR.id

Line 1216: FROM OKC_K_HEADERS_B CHR,

1212: CURSOR get_ia_lines_csr (p_ia_id IN NUMBER) IS
1213: SELECT CLE.id,
1214: CLE.name,
1215: CLE.sts_code
1216: FROM OKC_K_HEADERS_B CHR,
1217: OKC_K_LINES_V CLE
1218: WHERE CHR.id = p_ia_id
1219: AND CHR.id = CLE.dnz_chr_id
1220: AND CLE.sts_code = CHR.sts_code;

Line 2215: OKC_K_HEADERS_B KHR

2211: -- get the active pools for the IA
2212: CURSOR get_pools_csr(p_ia_id IN NUMBER) IS
2213: SELECT POL.id
2214: FROM OKL_POOLS POL,
2215: OKC_K_HEADERS_B KHR
2216: WHERE KHR.id = p_ia_id
2217: AND KHR.id = POL.khr_id
2218: AND POL.status_code = 'ACTIVE'; -- ACTIVE
2219:

Line 2784: FROM OKC_K_HEADERS_B CHR

2780:
2781: -- Get the latest IA Status
2782: CURSOR ia_status_csr (p_ia_id IN NUMBER) IS
2783: SELECT CHR.sts_code status
2784: FROM OKC_K_HEADERS_B CHR
2785: WHERE CHR.id = p_ia_id;
2786:
2787: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
2788: l_overall_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 3145: FROM OKC_K_HEADERS_B CHR

3141: -- Get the IAs which have reached their end_date and still active and no processed trn exists
3142: CURSOR get_expired_ia_csr (p_date IN DATE) IS
3143: SELECT CHR.id,
3144: CHR.contract_number
3145: FROM OKC_K_HEADERS_B CHR
3146: WHERE CHR.scs_code = 'INVESTOR' -- IA
3147: AND CHR.sts_code = 'ACTIVE' -- ACTIVE
3148: AND CHR.date_terminated IS NULL -- Not Terminated
3149: AND CHR.end_date <= TRUNC(p_date) -- Ended -- RMUNJULU 115.4 3061748 Changed to pick equal dates