DBA Data[Home] [Help]

APPS.JTA_SYNC_TASK_COMMON dependencies on JTF_RS_GROUP_MEMBERS

Line 825: FROM jtf_rs_group_members

821: IS
822: CURSOR c_group_id (b_resource_id IN VARCHAR2)
823: IS
824: SELECT group_id resource_id
825: FROM jtf_rs_group_members
826: WHERE resource_id = b_resource_id
827: AND delete_flag <> 'Y';
828:
829: CURSOR c_team_id (b_resource_id IN VARCHAR2)

Line 1788: FROM jtf_rs_group_members gm

1784: UNION ALL
1785: SELECT gm.group_id resource_id
1786: , 'RS_GROUP' resource_type_code
1787: , 'N' group_calendar_flag
1788: FROM jtf_rs_group_members gm
1789: WHERE gm.resource_id = p_resource_id
1790: UNION ALL
1791: SELECT g.group_id resource_id
1792: , 'RS_GROUP' resource_type_code