APPS.OKC_UTIL dependencies on OKC_SUBCLASS_RESPS

Line 1636: l_resp_access okc_subclass_resps.access_level%TYPE;

1632: l_modify_access CONSTANT Varchar2(1) := 'U';
1633: l_read_access CONSTANT Varchar2(1) := 'R';
1634: l_no_access CONSTANT Varchar2(1) := 'N';
1635:
1636: l_resp_access okc_subclass_resps.access_level%TYPE;
1637: l_resource_access okc_subclass_resps.access_level%TYPE;
1638: l_group_access okc_k_accesses.access_level%TYPE;
1639: l_group_id okc_k_accesses.group_id%TYPE;
1640:

Line 1637: l_resource_access okc_subclass_resps.access_level%TYPE;

1633: l_read_access CONSTANT Varchar2(1) := 'R';
1634: l_no_access CONSTANT Varchar2(1) := 'N';
1635:
1636: l_resp_access okc_subclass_resps.access_level%TYPE;
1637: l_resource_access okc_subclass_resps.access_level%TYPE;
1638: l_group_access okc_k_accesses.access_level%TYPE;
1639: l_group_id okc_k_accesses.group_id%TYPE;
1640:
1641: l_row_notfound Boolean;

Line 1670: FROM okc_subclass_resps ras

1666: -- user's responsibility to the sub class
1667:
1668: CURSOR resp_csr IS
1669: SELECT ras.access_level
1670: FROM okc_subclass_resps ras
1671: WHERE ras.scs_code = l_scs_code
1672: AND ras.resp_id = fnd_global.resp_id
1673: AND l_date BETWEEN ras.start_date AND nvl(ras.end_date, l_date);
1674:

Line 2087: from okc_subclass_resps_v

2083: FUNCTION Create_K_Access(p_scs_code varchar2) RETURN BOOLEAN IS
2084:
2085: Cursor access_level_csr is
2086: Select access_level
2087: from okc_subclass_resps_v
2088: where scs_code=p_scs_code
2089: and resp_id=fnd_global.resp_id
2090: and sysdate between start_date and nvl(end_date,sysdate);
2091: