[Home] [Help]
3213: WHEN no_data_found THEN
3214: BEGIN
3215: SELECT team_id
3216: INTO l_resource_id
3217: FROM jtf_rs_team_members
3218: WHERE team_resource_id = l_rs_id
3219: AND team_id IN (SELECT resource_id
3220: FROM jtf_task_all_assignments
3221: WHERE task_id = p_task_id
3312: rec_group c_group%ROWTYPE;
3313:
3314: CURSOR c_team (pc_rs_id NUMBER) IS
3315: SELECT team_id
3316: FROM jtf_rs_team_members
3317: WHERE team_resource_id = pc_rs_id
3318: AND team_id IN (SELECT resource_id
3319: FROM jtf_task_all_assignments
3320: WHERE task_id = p_task_id