APPS.JTF_RS_RESOURCE_UTL_PUB dependencies on JTF_RS_GROUPS_DENORM
Line 574: FROM jtf_rs_groups_denorm
570: l_mgr number := 0;
571:
572: CURSOR parent_grp_cur(l_group_id number) IS
573: SELECT parent_group_id 574: FROM jtf_rs_groups_denorm 575: WHERE group_id = l_group_id
576: AND group_id <> parent_group_id
577: AND trunc(sysdate) between start_date_active and nvl(end_date_active, trunc(sysdate));
578: