APPS.OKL_LA_ASSET_PVT dependencies on OKC_K_HEADERS_B

Line 503: FROM okc_k_headers_b CHR

499: l_return_value VARCHAR2(1) := '';
500: --cursor to check if contract has re-lease assets
501: CURSOR l_chk_rel_ast_csr (p_chr_id IN Number) IS
502: SELECT 'x'
503: FROM okc_k_headers_b CHR
504: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
505: AND chr.ID = p_chr_id
506: AND exists (SELECT '1'
507: FROM OKC_RULES_B rul

Line 1085: FROM okc_k_headers_b chr,

1081: IS
1082: SELECT st.ste_code,
1083: khr.deal_type
1084: -- FROM OKL_K_HEADERS_FULL_V chr,
1085: FROM okc_k_headers_b chr,
1086: okl_k_headers khr,
1087: okc_statuses_b st
1088: WHERE khr.id = chr.id
1089: and chr.id = p_chr_id

Line 2776: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

2772: lp_klev_rec OKL_CONTRACT_PUB.klev_rec_type;
2773: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2774: lx_klev_rec OKL_CONTRACT_PUB.klev_rec_type;
2775:
2776: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
2777: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
2778: BEGIN
2779: /*
2780: OKL_CONTEXT.SET_OKL_ORG_CONTEXT(

Line 2777: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

2773: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2774: lx_klev_rec OKL_CONTRACT_PUB.klev_rec_type;
2775:
2776: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
2777: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
2778: BEGIN
2779: /*
2780: OKL_CONTEXT.SET_OKL_ORG_CONTEXT(
2781: p_org_id => p_org_id,

Line 2890: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

2886:
2887: lp_vndr_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
2888: lx_vndr_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
2889:
2890: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
2891: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
2892:
2893: l_vendor_id NUMBER:= null;
2894: --start modifying abhsaxen cursor is no longer used

Line 2891: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

2887: lp_vndr_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
2888: lx_vndr_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
2889:
2890: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
2891: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
2892:
2893: l_vendor_id NUMBER:= null;
2894: --start modifying abhsaxen cursor is no longer used
2895: -- CURSOR okx_vendor_id1_csr IS