APPS.OKL_LA_ASSET_PVT dependencies on OKC_K_HEADERS_B

Line 507: FROM okc_k_headers_b CHR

503: -- Bug# 15992711 : The re-leased flag is no longer checked at contract header
504: -- Hence the cursor is modified to select 'X' only for a pure
505: -- released asset contract
506: /* SELECT 'x'
507: FROM okc_k_headers_b CHR
508: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
509: AND chr.ID = p_chr_id
510: AND exists (SELECT '1'
511: FROM OKC_RULES_B rul

Line 517: FROM okc_k_headers_b CHR

513: AND rul.rule_information_category = 'LARLES'
514: AND nvl(rule_information1,'N') = 'Y');
515: */
516: SELECT 'x'
517: FROM okc_k_headers_b CHR
518: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
519: AND chr.ID = p_chr_id
520: AND exists (SELECT '1'
521: FROM okc_k_lines_b CLEB

Line 1113: FROM okc_k_headers_b chr,

1109: IS
1110: SELECT st.ste_code,
1111: khr.deal_type
1112: -- FROM OKL_K_HEADERS_FULL_V chr,
1113: FROM okc_k_headers_b chr,
1114: okl_k_headers khr,
1115: okc_statuses_b st
1116: WHERE khr.id = chr.id
1117: and chr.id = p_chr_id

Line 2804: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

2800: lp_klev_rec OKL_CONTRACT_PUB.klev_rec_type;
2801: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2802: lx_klev_rec OKL_CONTRACT_PUB.klev_rec_type;
2803:
2804: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
2805: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
2806: BEGIN
2807: /*
2808: OKL_CONTEXT.SET_OKL_ORG_CONTEXT(

Line 2805: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

2801: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2802: lx_klev_rec OKL_CONTRACT_PUB.klev_rec_type;
2803:
2804: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
2805: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
2806: BEGIN
2807: /*
2808: OKL_CONTEXT.SET_OKL_ORG_CONTEXT(
2809: p_org_id => p_org_id,

Line 2918: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

2914:
2915: lp_vndr_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
2916: lx_vndr_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
2917:
2918: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
2919: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
2920:
2921: l_vendor_id NUMBER:= null;
2922: --start modifying abhsaxen cursor is no longer used

Line 2919: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

2915: lp_vndr_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
2916: lx_vndr_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
2917:
2918: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
2919: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
2920:
2921: l_vendor_id NUMBER:= null;
2922: --start modifying abhsaxen cursor is no longer used
2923: -- CURSOR okx_vendor_id1_csr IS