APPS.OKL_AM_TERMNT_VENDOR_PRG_PVT dependencies on OKC_K_HEADERS_B

Line 30: va_number OKC_K_HEADERS_B.contract_number%TYPE,

26:
27: -- Rec Type to Store Lease K Details
28: TYPE va_k_rec_type IS RECORD (
29: id NUMBER,
30: va_number OKC_K_HEADERS_B.contract_number%TYPE,
31: start_date DATE,
32: end_date DATE,
33: sts_code OKC_K_HEADERS_B.sts_code%TYPE,
34: date_terminated DATE);

Line 33: sts_code OKC_K_HEADERS_B.sts_code%TYPE,

29: id NUMBER,
30: va_number OKC_K_HEADERS_B.contract_number%TYPE,
31: start_date DATE,
32: end_date DATE,
33: sts_code OKC_K_HEADERS_B.sts_code%TYPE,
34: date_terminated DATE);
35:
36: -- Table Type to store Recs of IA Details
37: TYPE va_k_tbl_type IS TABLE OF va_k_rec_type INDEX BY BINARY_INTEGER;

Line 463: FROM OKC_K_HEADERS_B CHR,

459: CHR.START_DATE,
460: CHR.end_date,
461: CHR.sts_code, -- Should be ACTIVE
462: CHR.scs_code -- Should be PROGRAM or OPERATING
463: FROM OKC_K_HEADERS_B CHR,
464: OKL_K_HEADERS KHR
465: WHERE CHR.id = p_va_id
466: AND CHR.id = KHR.id;
467:

Line 1479: FROM OKC_K_HEADERS_B CHR

1475: -- This cursor should NOT be org specific as it needs to pick all VPAs
1476: CURSOR get_expired_va_csr (p_date IN DATE) IS
1477: SELECT CHR.id,
1478: CHR.contract_number va_number
1479: FROM OKC_K_HEADERS_B CHR
1480: WHERE CHR.scs_code IN ('PROGRAM','OPERATING') -- VPAs
1481: AND CHR.sts_code = 'ACTIVE' -- ACTIVE
1482: AND CHR.date_terminated IS NULL -- Not Terminated
1483: AND CHR.end_date <= TRUNC(p_date); -- Ended