DBA Data[Home] [Help]

APPS.OKS_AUTH_UTIL_PUB dependencies on OKC_STATUSES_V

Line 716: FROM okc_statuses_v

712:
713: FUNCTION def_sts_code(p_ste_code VARCHAR2) RETURN VARCHAR2 IS
714: CURSOR get_def_sts_code_csr IS
715: SELECT code
716: FROM okc_statuses_v
717: WHERE ste_code = p_ste_code
718: AND default_yn = 'Y';
719: get_def_sts_code_rec get_def_sts_code_csr%ROWTYPE;
720: BEGIN

Line 732: FROM okc_statuses_v

728:
729: FUNCTION get_ste_code(p_sts_code VARCHAR2) RETURN VARCHAR2 IS
730: CURSOR get_ste_code_csr IS
731: SELECT ste_code
732: FROM okc_statuses_v
733: WHERE code = p_sts_code;
734: get_ste_code_rec get_ste_code_csr%ROWTYPE;
735: BEGIN
736: