APPS.JTF_TASK_UTL dependencies on JTF_TASK_ALL_ASSIGNMENTS

Line 3209: FROM jtf_task_all_assignments

3205: INTO l_resource_id
3206: FROM jtf_rs_group_members
3207: WHERE resource_id = l_rs_id
3208: AND group_id IN (SELECT resource_id
3209: FROM jtf_task_all_assignments
3210: WHERE task_id = p_task_id
3211: AND resource_type_code = 'RS_GROUP');
3212: EXCEPTION
3213: WHEN no_data_found THEN

Line 3220: FROM jtf_task_all_assignments

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
3222: AND resource_type_code = 'RS_TEAM');
3223: EXCEPTION
3224: when no_data_found then

Line 3228: FROM jtf_task_all_assignments

3224: when no_data_found then
3225: -- compare user's id with the id list on assignment
3226: SELECT resource_id
3227: INTO l_resource_id
3228: FROM jtf_task_all_assignments
3229: WHERE task_id = p_task_id
3230: AND resource_id = l_rs_id;
3231:
3232:

Line 3308: FROM jtf_task_all_assignments

3304: SELECT group_id
3305: FROM jtf_rs_group_members
3306: WHERE resource_id = pc_rs_id
3307: AND group_id IN (SELECT resource_id
3308: FROM jtf_task_all_assignments
3309: WHERE task_id = p_task_id
3310: AND resource_type_code = 'RS_GROUP');
3311:
3312: rec_group c_group%ROWTYPE;

Line 3319: FROM jtf_task_all_assignments

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
3321: AND resource_type_code = 'RS_TEAM');
3322:
3323: rec_team c_team%ROWTYPE;

Line 3327: FROM jtf_task_all_assignments

3323: rec_team c_team%ROWTYPE;
3324:
3325: CURSOR c_assignee_or_owner (pc_rs_id NUMBER) IS
3326: SELECT resource_id
3327: FROM jtf_task_all_assignments
3328: WHERE task_id = p_task_id
3329: AND resource_id = pc_rs_id;
3330:
3331: rec_assignee_or_owner c_assignee_or_owner%ROWTYPE;

Line 3639: from jtf_task_all_assignments

3635: /* Make sure that only one row is returned */
3636: /* if the same resource is assigned to the task*/
3637: select category_id
3638: into l_category_id
3639: from jtf_task_all_assignments
3640: where task_id = p_task_id
3641: and resource_id = p_resource_id
3642: and resource_type_code = p_resource_type_code
3643: and rownum < 2 ;

Line 3667: update jtf_task_all_assignments

3663: set category = null
3664: where category in ( select perz_data_id from jtf_perz_data where perz_data_name = p_category_name ) ;
3665:
3666:
3667: update jtf_task_all_assignments
3668: set category_id = null
3669: where category_id in ( select perz_data_id from jtf_perz_data where perz_data_name = p_category_name ) ;
3670:
3671: