APPS.OKL_QA_DATA_INTEGRITY dependencies on OKC_K_HEADERS_V

Line 1324: FROM okc_k_headers_v WHERE id = p_id;

1320:
1321: -- gboomina modified for Bug 6329395 - Start
1322: CURSOR c_contract_name ( p_id VARCHAR2 ) IS
1323: SELECT contract_number
1324: FROM okc_k_headers_v WHERE id = p_id;
1325: l_contract_number OKC_K_HEADERS_ALL_B.CONTRACT_NUMBER%TYPE;
1326: -- gboomina modified for Bug 6329395 - End
1327:
1328: -- Bug 5114815

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

3243:
3244: --Bug 4917691 fmiao end ------------------------------------
3245:
3246:
3247: CURSOR con_type_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3248: SELECT 'Y'
3249: FROM okc_k_headers_b
3250: WHERE orig_system_source_code = 'OKL_REBOOK'
3251: AND id = p_chr_id;

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

3296: l_pct_sum NUMBER;
3297: l_pth_dtl_present_yn VARCHAR2(1);
3298:
3299: --Bug#3877032
3300: /*CURSOR pth_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3301: SELECT line.id,
3302: decode(style.lty_code,'SOLD_SERVICE','SERVICE',style.lty_code) line_type,
3303: nvl(line.name,line.item_description) name,
3304: line.fee_type,

Line 3730: FROM okc_k_headers_v WHERE contract_number = n;

3726:
3727:
3728: CURSOR l_contract_name ( n VARCHAR2 ) IS
3729: SELECT COUNT(*) cnt
3730: FROM okc_k_headers_v WHERE contract_number = n;
3731: l_cn l_contract_name%ROWTYPE;
3732:
3733:
3734: l_hdr l_hdr_csr%ROWTYPE;

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

4049: WHERE rule.id = p_slh_id
4050: AND rule.rule_information_category = 'LASLH'
4051: AND rule.object1_id1 = strm.id;
4052:
4053: CURSOR hdr_stub_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4054: SELECT
4055: 'Y' only_stub,
4056: rule.object2_id1
4057: FROM okc_rules_b rule,

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

4070: AND rule2.object2_id1 = rule.object2_id1
4071: );
4072:
4073: --Bug#3877032
4074: CURSOR line_stub_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4075: SELECT style.lty_code,
4076: style.name,
4077: rule.object2_id1,
4078: 'Y' stub_only

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

4651: p_chr_id IN NUMBER
4652: ) IS
4653:
4654: --Bug#3877032
4655: CURSOR con_type_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4656: SELECT NVL(okc.orig_system_source_code,'X') orig_system_source_code,
4657: NVL(okl.deal_type,'X') deal_type
4658: --FROM okl_k_headers_full_v
4659: FROM okc_k_headers_b okc,

Line 5167: From okc_k_headers_v where contract_number = n;

5163:
5164:
5165: CURSOR l_contract_name ( n VARCHAR2 ) IS
5166: Select count(*) cnt
5167: From okc_k_headers_v where contract_number = n;
5168: l_cn l_contract_name%ROWTYPE;
5169:
5170:
5171: l_hdr l_hdr_csr%ROWTYPE;

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

5387: PROCEDURE check_fee_lines(
5388: x_return_status OUT NOCOPY VARCHAR2,
5389: p_chr_id IN NUMBER
5390: ) IS
5391: CURSOR fee_line_csr (p_chrId OKC_K_HEADERS_V.ID%TYPE) IS
5392: SELECT l.id,
5393: l.line_number,
5394: l.start_date,
5395: l.end_date,

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

10599: SELECT start_date
10600: FROM okc_k_headers_b
10601: WHERE id = p_chr_id;
10602:
10603: CURSOR fee_topline_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
10604: SELECT line.id,
10605: NVL(line.capital_amount,0) capital_amount,
10606: line.start_date,
10607: strm.code strm_type

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

11011: x_return_status OUT NOCOPY VARCHAR2,
11012: p_chr_id IN NUMBER
11013: ) IS
11014:
11015: CURSOR asset_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
11016: SELECT line.id,
11017: line.name
11018: FROM okl_k_lines_full_v line,
11019: okc_line_styles_v style,