DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_WEB dependencies on CS_SYSTEMS_ALL_TL

Line 259: CS_SYSTEMS_ALL_TL T

255: FROM OKC_K_PARTY_ROLES_B rle,
256: OKC_K_HEADERS_ALL_V hdr1,
257: okc_k_items itm,
258: CS_SYSTEMS_ALL_B B,
259: CS_SYSTEMS_ALL_TL T
260: WHERE rle.jtot_object1_code='OKX_PARTY'
261: and rle.object1_id1 =to_number(p_party_id)
262: and rle.rle_code in ('CUSTOMER', 'SUBSCRIBER')
263: AND RLE.CLE_ID IS NULL

Line 753: CS_SYSTEMS_ALL_TL T

749: FROM OKC_K_PARTY_ROLES_B rle,
750: OKC_K_HEADERS_ALL_V hdr1,
751: okc_k_items itm,
752: CS_SYSTEMS_ALL_B B,
753: CS_SYSTEMS_ALL_TL T
754: WHERE rle.jtot_object1_code='OKX_PARTY'
755: and rle.object1_id1 =to_number(p_party_id)
756: and rle.rle_code in ('CUSTOMER', 'SUBSCRIBER')
757: AND RLE.CLE_ID IS NULL

Line 2310: from CS_SYSTEMS_ALL_TL

2306: p_itm_obj2_arg VARCHAR2
2307: )
2308: IS
2309: select name
2310: from CS_SYSTEMS_ALL_TL
2311: where system_id = to_number(p_itm_obj1_arg)
2312: and language = userenv('lang');
2313:
2314: CURSOR coverage_site_cur(