DBA Data[Home] [Help]

APPS.JTF_TASK_UTL dependencies on JTF_RS_GROUP_MEMBERS

Line 3206: FROM jtf_rs_group_members

3202: BEGIN
3203: -- check when resource_type_code is a group
3204: SELECT group_id
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

Line 3305: FROM jtf_rs_group_members

3301: rec_resource c_resource%ROWTYPE;
3302:
3303: CURSOR c_group (pc_rs_id NUMBER) IS
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