DBA Data[Home] [Help]

APPS.CAC_SYNC_TASK_COMMON dependencies on JTF_RS_TEAM_MEMBERS

Line 943: FROM jtf_rs_team_members

939:
940: CURSOR c_team_id (b_resource_id IN VARCHAR2)
941: IS
942: SELECT team_id resource_id
943: FROM jtf_rs_team_members
944: WHERE team_resource_id = b_resource_id
945: AND delete_flag <> 'Y';
946:
947: l_group_resource_tbl resource_list_tbl;

Line 2107: FROM jtf_rs_team_members tm

2103: UNION ALL
2104: SELECT tm.team_id resource_id
2105: , 'RS_TEAM' resource_type_code
2106: , 'N' group_calendar_flag
2107: FROM jtf_rs_team_members tm
2108: WHERE tm.team_resource_id = p_resource_id
2109: UNION ALL
2110: SELECT gm.group_id resource_id
2111: , 'RS_GROUP' resource_type_code