APPS.OKS_MASSCHANGE_PVT dependencies on OKC_STATUSES_V

Line 7629: SELECT ste_code FROM okc_statuses_v WHERE code = sts_code;

7625: FUNCTION Get_ste_code(p_sts_code IN Varchar2)
7626: RETURN Varchar2 IS
7627: l_ste_code Varchar2(50):= NULL;
7628: CURSOR Get_ste_code(sts_code IN Varchar2) IS
7629: SELECT ste_code FROM okc_statuses_v WHERE code = sts_code;
7630: BEGIN
7631: OPEN Get_ste_code(p_sts_code);
7632: FETCH Get_ste_code INTO l_ste_code;
7633: CLOSE Get_ste_code;