APPS.OKL_QA_DATA_INTEGRITY dependencies on OKC_K_HEADERS_V

Line 1306: FROM okc_k_headers_v WHERE id = p_id;

1302:
1303: -- gboomina modified for Bug 6329395 - Start
1304: CURSOR c_contract_name ( p_id VARCHAR2 ) IS
1305: SELECT contract_number
1306: FROM okc_k_headers_v WHERE id = p_id;
1307: l_contract_number OKC_K_HEADERS_ALL_B.CONTRACT_NUMBER%TYPE;
1308: -- gboomina modified for Bug 6329395 - End
1309:
1310: --Added end_date by bkatraga for bug 13478101

Line 3432: CURSOR con_type_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

3428:
3429: --Bug 4917691 fmiao end ------------------------------------
3430:
3431:
3432: CURSOR con_type_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3433: SELECT 'Y'
3434: FROM okc_k_headers_b
3435: WHERE orig_system_source_code = 'OKL_REBOOK'
3436: AND id = p_chr_id;

Line 3485: /*CURSOR pth_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

3481: l_pct_sum NUMBER;
3482: l_pth_dtl_present_yn VARCHAR2(1);
3483:
3484: --Bug#3877032
3485: /*CURSOR pth_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3486: SELECT line.id,
3487: decode(style.lty_code,'SOLD_SERVICE','SERVICE',style.lty_code) line_type,
3488: nvl(line.name,line.item_description) name,
3489: line.fee_type,

Line 4052: FROM okc_k_headers_v WHERE contract_number = n;

4048:
4049:
4050: CURSOR l_contract_name ( n VARCHAR2 ) IS
4051: SELECT COUNT(*) cnt
4052: FROM okc_k_headers_v WHERE contract_number = n;
4053: l_cn l_contract_name%ROWTYPE;
4054:
4055:
4056: l_hdr l_hdr_csr%ROWTYPE;

Line 4375: CURSOR hdr_stub_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

4371: WHERE rule.id = p_slh_id
4372: AND rule.rule_information_category = 'LASLH'
4373: AND rule.object1_id1 = strm.id;
4374:
4375: CURSOR hdr_stub_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4376: SELECT
4377: 'Y' only_stub,
4378: rule.object2_id1
4379: FROM okc_rules_b rule,

Line 4396: CURSOR line_stub_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

4392: AND rule2.object2_id1 = rule.object2_id1
4393: );
4394:
4395: --Bug#3877032
4396: CURSOR line_stub_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4397: SELECT style.lty_code,
4398: style.name,
4399: rule.object2_id1,
4400: 'Y' stub_only

Line 5042: CURSOR con_type_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

5038: p_chr_id IN NUMBER
5039: ) IS
5040:
5041: --Bug#3877032
5042: CURSOR con_type_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5043: SELECT NVL(okc.orig_system_source_code,'X') orig_system_source_code,
5044: NVL(okl.deal_type,'X') deal_type
5045: --FROM okl_k_headers_full_v
5046: FROM okc_k_headers_b okc,

Line 5554: From okc_k_headers_v where contract_number = n;

5550:
5551:
5552: CURSOR l_contract_name ( n VARCHAR2 ) IS
5553: Select count(*) cnt
5554: From okc_k_headers_v where contract_number = n;
5555: l_cn l_contract_name%ROWTYPE;
5556:
5557:
5558: l_hdr l_hdr_csr%ROWTYPE;

Line 5778: CURSOR fee_line_csr (p_chrId OKC_K_HEADERS_V.ID%TYPE) IS

5774: PROCEDURE check_fee_lines(
5775: x_return_status OUT NOCOPY VARCHAR2,
5776: p_chr_id IN NUMBER
5777: ) IS
5778: CURSOR fee_line_csr (p_chrId OKC_K_HEADERS_V.ID%TYPE) IS
5779: SELECT l.id,
5780: l.line_number,
5781: l.start_date,
5782: l.end_date,

Line 11026: CURSOR fee_topline_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

11022: SELECT start_date
11023: FROM okc_k_headers_b
11024: WHERE id = p_chr_id;
11025:
11026: CURSOR fee_topline_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
11027: SELECT line.id,
11028: NVL(line.capital_amount,0) capital_amount,
11029: line.start_date,
11030: strm.code strm_type

Line 11438: CURSOR asset_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

11434: x_return_status OUT NOCOPY VARCHAR2,
11435: p_chr_id IN NUMBER
11436: ) IS
11437:
11438: CURSOR asset_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
11439: SELECT line.id,
11440: line.name
11441: FROM okl_k_lines_full_v line,
11442: okc_line_styles_v style,