APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 6920: from okl_k_headers_full_v

6916: and mla.contract_number = p_mla_no;
6917:
6918: cursor get_k_id_csr(p_k_no IN VARCHAR2) is
6919: select id
6920: from okl_k_headers_full_v
6921: where contract_number = p_k_no;
6922:
6923: BEGIN
6924:

Line 7217: l_chr_id okl_k_headers_full_v.id%type;

7213: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
7214: l_object_code VARCHAR2(30) Default Null;
7215:
7216: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
7217: l_chr_id okl_k_headers_full_v.id%type;
7218: l_revolving_credit_yn okl_k_headers_full_v.revolving_credit_yn%type;
7219: l_row_count number;
7220: l_currency_code fnd_currencies_vl.currency_code%type := null;
7221:

Line 7218: l_revolving_credit_yn okl_k_headers_full_v.revolving_credit_yn%type;

7214: l_object_code VARCHAR2(30) Default Null;
7215:
7216: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
7217: l_chr_id okl_k_headers_full_v.id%type;
7218: l_revolving_credit_yn okl_k_headers_full_v.revolving_credit_yn%type;
7219: l_row_count number;
7220: l_currency_code fnd_currencies_vl.currency_code%type := null;
7221:
7222: cursor l_chk_cust_acc_csr(p_cust_acc_id1 VARCHAR2, p_name VARCHAR2) is

Line 7238: from OKL_k_headers_full_V

7234: and nvl(to_date,p_start_date+1) > p_start_date;
7235:
7236: cursor l_mla_csr is
7237: select id
7238: from OKL_k_headers_full_V
7239: where contract_number = p_mla_no
7240: and scs_code = 'MASTER_LEASE'
7241: and STS_CODE = 'ACTIVE'
7242: and TEMPLATE_YN = 'N'

Line 7247: from OKL_k_headers_full_V prg_hdr

7243: and BUY_OR_SELL = 'S';
7244:
7245: cursor l_program_csr is
7246: select id
7247: from OKL_k_headers_full_V prg_hdr
7248: where contract_number = p_program_no
7249: and scs_code = 'PROGRAM'
7250: and nvl(TEMPLATE_YN, 'N') = 'N'
7251: and sts_code = 'ACTIVE'