APPS.JTF_RS_RESOURCE_UTL_PUB dependencies on JTF_RS_GROUPS_DENORM
Line 586: FROM jtf_rs_groups_denorm
582: l_mgr number := 0;
583:
584: CURSOR parent_grp_cur(l_group_id number) IS
585: SELECT parent_group_id 586: FROM jtf_rs_groups_denorm 587: WHERE group_id = l_group_id
588: AND group_id <> parent_group_id
589: AND trunc(sysdate) between start_date_active and nvl(end_date_active, trunc(sysdate));
590: