DBA Data[Home] [Help]

APPS.CS_KB_WF_PKG dependencies on JTF_RS_GROUPS_VL

Line 741: FROM JTF_RS_GROUPS_VL g,

737:
738: CURSOR All_Groups IS
739: SELECT g.GROUP_ID,
740: g.GROUP_NAME
741: FROM JTF_RS_GROUPS_VL g,
742: JTF_RS_GROUP_USAGES u
743: WHERE g.GROUP_ID = u.GROUP_ID
744: AND u.USAGE = 'ISUPPORT'
745: AND NVL(g.END_DATE_ACTIVE, sysdate) >= sysdate

Line 1717: FROM JTF_RS_GROUPS_VL

1713: adhoc_role_name VARCHAR2(360);
1714:
1715: CURSOR GET_GROUP_NAME (v_group_id NUMBER) IS
1716: SELECT GROUP_NAME
1717: FROM JTF_RS_GROUPS_VL
1718: WHERE GROUP_ID = v_group_id;
1719:
1720:
1721: CURSOR Get_Group_Members (v_group_id IN NUMBER) IS