APPS.OKS_BILL_REC_PUB dependencies on OKC_K_REL_OBJS

Line 2005: SELECT id FROM OKC_K_REL_OBJS_V

2001:
2002:
2003:
2004: Cursor l_rel_csr_cov (p_line_id in NUMBER) Is
2005: SELECT id FROM OKC_K_REL_OBJS_V
2006: WHERE cle_id = p_line_id;
2007:
2008: Cursor l_rel_csr (p_line_id in NUMBER) Is
2009: SELECT obj.id FROM OKC_K_REL_OBJS_V obj,

Line 2009: SELECT obj.id FROM OKC_K_REL_OBJS_V obj,

2005: SELECT id FROM OKC_K_REL_OBJS_V
2006: WHERE cle_id = p_line_id;
2007:
2008: Cursor l_rel_csr (p_line_id in NUMBER) Is
2009: SELECT obj.id FROM OKC_K_REL_OBJS_V obj,
2010: OKC_K_LINES_B ln
2011: WHERE obj.cle_id = ln.id
2012: AND ln.cle_id = p_line_id;
2013:

Line 5389: From OKC_K_REL_OBJS_V obj,

5385: AND rline.cle_id = line.id;
5386:
5387: CURSOR l_rel_csr Is
5388: SELECT obj.id
5389: From OKC_K_REL_OBJS_V obj,
5390: OKC_K_LINES_B ln
5391: Where obj.cle_id = ln.id
5392: And ln.cle_id = p_k_line_id;
5393:

Line 7830: Select 1 from okc_k_rel_objs

7826: AND tl.language = USERENV('LANG');
7827:
7828:
7829: Cursor l_okl_contract_csr(p_chr_id IN NUMBER) is
7830: Select 1 from okc_k_rel_objs
7831: where rty_code in ('OKLSRV','OKLUBB')
7832: and jtot_object1_code = 'OKL_SERVICE'
7833: and object1_id1 = to_char(p_chr_id);
7834:

Line 8117: SELECT id FROM OKC_K_REL_OBJS_V

8113: X_RETURN_STATUS OUT NOCOPY VARCHAR2
8114: )IS
8115:
8116: Cursor l_rel_csr (p_line_id in Number) Is
8117: SELECT id FROM OKC_K_REL_OBJS_V
8118: WHERE cle_id = p_line_id ;
8119:
8120: Cursor check_term_cur(p_cle_id NUMBER) is
8121: SELECT bsl.id,

Line 9946: from okc_k_rel_objs rel,

9942:
9943: CURSOR om_period_csr(p_id IN NUMBER) IS
9944: select oel.service_period,oel.service_duration,
9945: oel.ordered_quantity
9946: from okc_k_rel_objs rel,
9947: oe_order_lines_all oel
9948: where rel.cle_id = p_id
9949: and oel.line_id = rel.object1_id1;
9950:

Line 10373: from okc_k_rel_objs rel,

10369:
10370: CURSOR om_period_csr(p_id IN NUMBER) IS
10371: select oel.service_period,oel.service_duration,
10372: oel.ordered_quantity
10373: from okc_k_rel_objs rel,
10374: oe_order_lines_all oel
10375: where rel.cle_id = p_id
10376: and oel.line_id = rel.object1_id1;
10377: