APPS.OKC_QA_DATA_INTEGRITY dependencies on OKC_K_LINES_B

Line 243: CURSOR l_cle_csr(p_id okc_k_lines_b.id%TYPE) IS

239: WHERE chrv.id = p_chr_id
240: AND sub.code = chrv.scs_code;
241: l_chrv_rec l_chrv_csr%ROWTYPE;
242:
243: CURSOR l_cle_csr(p_id okc_k_lines_b.id%TYPE) IS
244: SELECT cle.chr_id
245: FROM OKC_K_LINES_B cle
246: WHERE cle.id = p_id;
247: l_cle_rec l_cle_csr%ROWTYPE;

Line 245: FROM OKC_K_LINES_B cle

241: l_chrv_rec l_chrv_csr%ROWTYPE;
242:
243: CURSOR l_cle_csr(p_id okc_k_lines_b.id%TYPE) IS
244: SELECT cle.chr_id
245: FROM OKC_K_LINES_B cle
246: WHERE cle.id = p_id;
247: l_cle_rec l_cle_csr%ROWTYPE;
248:
249: CURSOR l_chr_csr IS

Line 1101: CURSOR l_cle_csr(p_id okc_k_lines_b.id%TYPE) IS

1097: WHERE rgp_id = l_rgp_rec.id;
1098:
1099: l_rul_rec OKC_RULES_B%ROWTYPE;
1100:
1101: CURSOR l_cle_csr(p_id okc_k_lines_b.id%TYPE) IS
1102: SELECT cle.chr_id
1103: FROM OKC_K_LINES_B cle
1104: WHERE cle.id = p_id;
1105: l_cle_rec l_cle_csr%ROWTYPE;

Line 1103: FROM OKC_K_LINES_B cle

1099: l_rul_rec OKC_RULES_B%ROWTYPE;
1100:
1101: CURSOR l_cle_csr(p_id okc_k_lines_b.id%TYPE) IS
1102: SELECT cle.chr_id
1103: FROM OKC_K_LINES_B cle
1104: WHERE cle.id = p_id;
1105: l_cle_rec l_cle_csr%ROWTYPE;
1106:
1107: l_prev_rgp_rec_id Number := -1;

Line 1659: FROM OKC_K_LINES_B

1655: CURSOR l_cle_csr IS
1656: /**
1657: SELECT level, start_date, end_date, line_number,
1658: id, chr_id, cle_id,lse_id
1659: FROM OKC_K_LINES_B
1660: WHERE date_cancelled is null --changes [llc]-- bug #4727744 -- to ignore cancelled lines
1661: START WITH chr_id = p_chr_id
1662: CONNECT BY PRIOR id = cle_id
1663: AND date_cancelled is NULL; --changes [llc]-- to ignore cancelled sublines

Line 1670: FROM okc_k_lines_b kla,

1666: SELECT kla.start_date, kla.end_date,
1667: kla.id, kla.chr_id, kla.lse_id,
1668: --
1669: klb.start_date parent_start_date, klb.end_date parent_end_date
1670: FROM okc_k_lines_b kla,
1671: okc_k_lines_b klb
1672: WHERE kla.dnz_chr_id = p_chr_id
1673: AND kla.cle_id = klb.id (+)
1674: AND kla.date_cancelled is NULL

Line 1671: okc_k_lines_b klb

1667: kla.id, kla.chr_id, kla.lse_id,
1668: --
1669: klb.start_date parent_start_date, klb.end_date parent_end_date
1670: FROM okc_k_lines_b kla,
1671: okc_k_lines_b klb
1672: WHERE kla.dnz_chr_id = p_chr_id
1673: AND kla.cle_id = klb.id (+)
1674: AND kla.date_cancelled is NULL
1675: AND klb.date_cancelled is NULL;