APPS.OKL_CREDIT_PUB dependencies on OKL_CRD_FUND_CHKLST_TPL_HDR_UV

Line 772: from okl_crd_fund_chklst_tpl_hdr_uv hdr

768: -- existing funding request checklist template header
769: ---------------------------------------------------------
770: cursor c_chk_tpl_hdr (p_chr_id okc_rules_b.dnz_chr_id%type) is
771: select hdr.ID
772: from okl_crd_fund_chklst_tpl_hdr_uv hdr
773: where hdr.khr_id = p_chr_id
774: ;
775:
776:

Line 1380: l_status okl_crd_fund_chklst_tpl_hdr_uv.status%TYPE;

1376: l_checklists_row_found boolean;
1377:
1378: l_dummy number;
1379:
1380: l_status okl_crd_fund_chklst_tpl_hdr_uv.status%TYPE;
1381: l_effective_to okl_crd_fund_chklst_tpl_hdr_uv.effective_to%TYPE;
1382:
1383: --------------------------------------------------------------------------------------------
1384: --1 This is used for existing credit line and user try to activate credit line w/o activate

Line 1381: l_effective_to okl_crd_fund_chklst_tpl_hdr_uv.effective_to%TYPE;

1377:
1378: l_dummy number;
1379:
1380: l_status okl_crd_fund_chklst_tpl_hdr_uv.status%TYPE;
1381: l_effective_to okl_crd_fund_chklst_tpl_hdr_uv.effective_to%TYPE;
1382:
1383: --------------------------------------------------------------------------------------------
1384: --1 This is used for existing credit line and user try to activate credit line w/o activate
1385: -- checklists

Line 1418: from okl_crd_fund_chklst_tpl_hdr_uv chk

1414: CURSOR c_fund_chklst_sts (p_chr_id okc_k_headers_b.id%type)
1415: IS
1416: select chk.status,
1417: chk.effective_to
1418: from okl_crd_fund_chklst_tpl_hdr_uv chk
1419: where chk.khr_id = p_chr_id
1420: ;
1421:
1422: --------------------------------------------------------------------------------------------