DBA Data[Home] [Help]

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: