DBA Data[Home] [Help]

APPS.JTA_SYNC_TASK_COMMON dependencies on JTF_RS_TEAM_MEMBERS

Line 832: FROM jtf_rs_team_members

828:
829: CURSOR c_team_id (b_resource_id IN VARCHAR2)
830: IS
831: SELECT team_id resource_id
832: FROM jtf_rs_team_members
833: WHERE team_resource_id = b_resource_id
834: AND delete_flag <> 'Y';
835:
836: l_group_resource_tbl resource_list_tbl;

Line 1782: FROM jtf_rs_team_members tm

1778: UNION ALL
1779: SELECT tm.team_id resource_id
1780: , 'RS_TEAM' resource_type_code
1781: , 'N' group_calendar_flag
1782: FROM jtf_rs_team_members tm
1783: WHERE tm.team_resource_id = p_resource_id
1784: UNION ALL
1785: SELECT gm.group_id resource_id
1786: , 'RS_GROUP' resource_type_code