DBA Data[Home] [Help]

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: