DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_WEB dependencies on OKC_SUBCLASSES_V

Line 955: SELECT CODE, MEANING FROM OKC_SUBCLASSES_V WHERE CLS_CODE = 'SERVICE' ORDER BY MEANING;

951: IS
952: SELECT party_name FROM hz_parties WHERE party_id=p_party_id;
953: CURSOR contract_cat_cur
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:

Line 1273: OKC_SUBCLASSES_V cat,

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
1277: hdr.ID = to_number(p_contract_id_arg)