APPS.OKS_BILL_REC_PUB dependencies on OKC_K_REL_OBJS

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 7862: Select 1 from okc_k_rel_objs

7858: AND tl.language = USERENV('LANG');
7859:
7860:
7861: Cursor l_okl_contract_csr(p_chr_id IN NUMBER) is
7862: Select 1 from okc_k_rel_objs
7863: where rty_code in ('OKLSRV','OKLUBB')
7864: and jtot_object1_code = 'OKL_SERVICE'
7865: and object1_id1 = to_char(p_chr_id);
7866:

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,

Line 10036: from okc_k_rel_objs rel,

10032:
10033: CURSOR om_period_csr(p_id IN NUMBER) IS
10034: select oel.service_period,oel.service_duration,
10035: oel.ordered_quantity
10036: from okc_k_rel_objs rel,
10037: oe_order_lines_all oel
10038: where rel.cle_id = p_id
10039: and oel.line_id = rel.object1_id1;
10040:

Line 10491: from okc_k_rel_objs rel,

10487:
10488: CURSOR om_period_csr(p_id IN NUMBER) IS
10489: select oel.service_period,oel.service_duration,
10490: oel.ordered_quantity
10491: from okc_k_rel_objs rel,
10492: oe_order_lines_all oel
10493: where rel.cle_id = p_id
10494: and oel.line_id = rel.object1_id1;
10495: