DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_WEB dependencies on OKC_STATUSES_V

Line 958: SELECT CODE, MEANING FROM OKC_STATUSES_V ORDER BY MEANING;

954: IS
955: SELECT CODE, MEANING FROM OKC_SUBCLASSES_V WHERE CLS_CODE = 'SERVICE' ORDER BY MEANING;
956: CURSOR contract_status_cur
957: IS
958: SELECT CODE, MEANING FROM OKC_STATUSES_V ORDER BY MEANING;
959:
960: l_contract_cat_tbl_type OKS_ENTITLEMENTS_WEB.contract_cat_tbl_type;
961: l_contract_status_tbl_type OKS_ENTITLEMENTS_WEB.contract_status_tbl_type;
962: l_party_name VARCHAR2(500);

Line 1272: OKC_STATUSES_V sts,

1268: hdr.END_DATE ContEndDate
1269: FROM
1270: OKC_K_REL_OBJS_V rel,
1271: OKX_ORDER_HEADERS_V ord,
1272: OKC_STATUSES_V sts,
1273: OKC_SUBCLASSES_V cat,
1274: OKC_K_VERS_NUMBERS_V ver,
1275: OKC_K_HEADERS_ALL_V hdr
1276: WHERE