APPS.OKL_CONTRACT_LINE_ITEM_PVT dependencies on OKC_K_REL_OBJS

Line 1126: from okc_k_rel_objs rel

1122: and name = p_name;
1123:
1124: CURSOR is_serv_contract_csr(p_cle_id number) IS
1125: select count(1)
1126: from okc_k_rel_objs rel
1127: where rel.cle_id = p_cle_id and
1128: rel.rty_code = 'OKLSRV';
1129:
1130: CURSOR get_k_info_csr(p_chr_id number) IS

Line 1608: from okc_k_rel_objs rel

1604: and name = p_name;
1605:
1606: CURSOR is_serv_contract_csr(p_cle_id number) IS
1607: select count(1)
1608: from okc_k_rel_objs rel
1609: where rel.cle_id = p_cle_id and
1610: rel.rty_code = 'OKLSRV';
1611:
1612: CURSOR get_k_info_csr(p_chr_id number) IS

Line 2906: FROM okc_k_rel_objs_v rlobj

2902:
2903: CURSOR get_serv_chr_from_serv(p_chr_id okc_k_headers_b.id%TYPE,
2904: p_line_id okc_k_lines_b.id%TYPE) IS
2905: SELECT rlobj.object1_id1
2906: FROM okc_k_rel_objs_v rlobj
2907: WHERE rlobj.chr_id = p_chr_id
2908: AND rlobj.cle_id = p_line_id
2909: AND rlobj.rty_code = 'OKLSRV'
2910: AND rlobj.jtot_object1_code = 'OKL_SERVICE_LINE';