APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 6904: from okl_k_headers_full_v

6900: and mla.contract_number = p_mla_no;
6901:
6902: cursor get_k_id_csr(p_k_no IN VARCHAR2) is
6903: select id
6904: from okl_k_headers_full_v
6905: where contract_number = p_k_no;
6906:
6907: BEGIN
6908:

Line 7201: l_chr_id okl_k_headers_full_v.id%type;

7197: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7198: l_object_code VARCHAR2(30) Default Null;
7199:
7200: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
7201: l_chr_id okl_k_headers_full_v.id%type;
7202: l_revolving_credit_yn okl_k_headers_full_v.revolving_credit_yn%type;
7203: l_row_count number;
7204: l_currency_code fnd_currencies_vl.currency_code%type := null;
7205:

Line 7202: l_revolving_credit_yn okl_k_headers_full_v.revolving_credit_yn%type;

7198: l_object_code VARCHAR2(30) Default Null;
7199:
7200: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
7201: l_chr_id okl_k_headers_full_v.id%type;
7202: l_revolving_credit_yn okl_k_headers_full_v.revolving_credit_yn%type;
7203: l_row_count number;
7204: l_currency_code fnd_currencies_vl.currency_code%type := null;
7205:
7206: cursor l_chk_cust_acc_csr(p_cust_acc_id1 VARCHAR2, p_name VARCHAR2) is

Line 7222: from OKL_k_headers_full_V

7218: and nvl(to_date,p_start_date+1) > p_start_date;
7219:
7220: cursor l_mla_csr is
7221: select id
7222: from OKL_k_headers_full_V
7223: where contract_number = p_mla_no
7224: and scs_code = 'MASTER_LEASE'
7225: and STS_CODE = 'ACTIVE'
7226: and TEMPLATE_YN = 'N'

Line 7231: from OKL_k_headers_full_V prg_hdr

7227: and BUY_OR_SELL = 'S';
7228:
7229: cursor l_program_csr is
7230: select id
7231: from OKL_k_headers_full_V prg_hdr
7232: where contract_number = p_program_no
7233: and scs_code = 'PROGRAM'
7234: and nvl(TEMPLATE_YN, 'N') = 'N'
7235: and sts_code = 'ACTIVE'