APPS.OKS_BILL_REC_PUB dependencies on OKC_K_REL_OBJS_V

Line 2019: SELECT id FROM OKC_K_REL_OBJS_V

2015:
2016:
2017:
2018: Cursor l_rel_csr_cov (p_line_id in NUMBER) Is
2019: SELECT id FROM OKC_K_REL_OBJS_V
2020: WHERE cle_id = p_line_id;
2021:
2022: Cursor l_rel_csr (p_line_id in NUMBER) Is
2023: SELECT obj.id FROM OKC_K_REL_OBJS_V obj,

Line 2023: SELECT obj.id FROM OKC_K_REL_OBJS_V obj,

2019: SELECT id FROM OKC_K_REL_OBJS_V
2020: WHERE cle_id = p_line_id;
2021:
2022: Cursor l_rel_csr (p_line_id in NUMBER) Is
2023: SELECT obj.id FROM OKC_K_REL_OBJS_V obj,
2024: OKC_K_LINES_B ln
2025: WHERE obj.cle_id = ln.id
2026: AND ln.cle_id = p_line_id;
2027:

Line 5415: From OKC_K_REL_OBJS_V obj,

5411: AND rline.cle_id = line.id;
5412:
5413: CURSOR l_rel_csr Is
5414: SELECT obj.id
5415: From OKC_K_REL_OBJS_V obj,
5416: OKC_K_LINES_B ln
5417: Where obj.cle_id = ln.id
5418: And ln.cle_id = p_k_line_id;
5419:

Line 8149: SELECT id FROM OKC_K_REL_OBJS_V

8145: X_RETURN_STATUS OUT NOCOPY VARCHAR2
8146: )IS
8147:
8148: Cursor l_rel_csr (p_line_id in Number) Is
8149: SELECT id FROM OKC_K_REL_OBJS_V
8150: WHERE cle_id = p_line_id ;
8151:
8152: Cursor check_term_cur(p_cle_id NUMBER) is
8153: SELECT bsl.id,