APPS.JTA_SYNC_TASK_COMMON dependencies on JTF_TASK_ALL_ASSIGNMENTS

Line 573: FROM jtf_task_all_assignments

569: IS
570: CURSOR c_task
571: IS
572: SELECT task_id
573: FROM jtf_task_all_assignments
574: WHERE task_assignment_id = p_task_assignment_id;
575:
576: l_task_id NUMBER;
577: BEGIN

Line 677: FROM jtf_task_all_assignments

673: IS
674: CURSOR c_assignment_ovn (b_task_assignment_id NUMBER)
675: IS
676: SELECT object_version_number
677: FROM jtf_task_all_assignments
678: WHERE task_assignment_id = b_task_assignment_id;
679:
680: l_object_version_number NUMBER;
681: BEGIN

Line 1509: FROM jtf_task_all_assignments

1505: IS
1506: CURSOR c_assignment
1507: IS
1508: SELECT task_assignment_id
1509: FROM jtf_task_all_assignments
1510: WHERE task_id = p_task_id
1511: AND resource_id = p_resource_id
1512: AND resource_type_code = p_resource_type;
1513:

Line 1546: FROM jtf_task_all_assignments

1542: IS
1543: CURSOR c_assignment
1544: IS
1545: SELECT assignment_status_id
1546: FROM jtf_task_all_assignments
1547: WHERE task_id = p_task_id
1548: AND resource_id = p_resource_id;
1549:
1550: l_assignment_status_id NUMBER;

Line 1621: FROM jtf_rs_resource_extns r, jtf_task_all_assignments a

1617: IS
1618: CURSOR c_assignment (b_task_id NUMBER, b_resource_id NUMBER)
1619: IS
1620: SELECT a.assignee_role, a.assignment_status_id, r.resource_id
1621: FROM jtf_rs_resource_extns r, jtf_task_all_assignments a
1622: WHERE a.task_id = b_task_id
1623: AND a.resource_id = b_resource_id
1624: AND r.user_id = a.created_by;
1625:

Line 1801: , jtf_task_all_assignments asg

1797: AND fg.grantee_type = 'USER'
1798: AND fg.instance_pk2_value = 'RS_GROUP'
1799: AND fg.instance_pk1_value = to_char(g.group_id)
1800: ) rs
1801: , jtf_task_all_assignments asg
1802: , jtf_tasks_b tsk
1803: WHERE asg.resource_type_code = rs.resource_type_code
1804: AND asg.resource_id = rs.resource_id
1805: AND asg.task_id = tsk.task_id