eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CAC_SYNC_TASK_COMMON dependencies on JTF_TASK_ALL_ASSIGNMENTS

Line 679: FROM jtf_task_all_assignments

675: IS
676: CURSOR c_task
677: IS
678: SELECT task_id
679: FROM jtf_task_all_assignments
680: WHERE task_assignment_id = p_task_assignment_id;
681:
682: l_task_id NUMBER;
683: BEGIN

Line 783: FROM jtf_task_all_assignments

779: IS
780: CURSOR c_assignment_ovn (b_task_assignment_id NUMBER)
781: IS
782: SELECT object_version_number
783: FROM jtf_task_all_assignments
784: WHERE task_assignment_id = b_task_assignment_id;
785:
786: l_object_version_number NUMBER;
787: BEGIN

Line 1834: FROM jtf_task_all_assignments

1830: IS
1831: CURSOR c_assignment
1832: IS
1833: SELECT task_assignment_id
1834: FROM jtf_task_all_assignments
1835: WHERE task_id = p_task_id
1836: AND resource_id = p_resource_id
1837: AND resource_type_code = p_resource_type;
1838:

Line 1871: FROM jtf_task_all_assignments

1867: IS
1868: CURSOR c_assignment
1869: IS
1870: SELECT assignment_status_id
1871: FROM jtf_task_all_assignments
1872: WHERE task_id = p_task_id
1873: AND resource_id = p_resource_id;
1874:
1875: l_assignment_status_id NUMBER;

Line 1946: FROM jtf_rs_resource_extns r, jtf_task_all_assignments a

1942: IS
1943: CURSOR c_assignment (b_task_id NUMBER, b_resource_id NUMBER)
1944: IS
1945: SELECT a.assignee_role, a.assignment_status_id, r.resource_id
1946: FROM jtf_rs_resource_extns r, jtf_task_all_assignments a
1947: WHERE a.task_id = b_task_id
1948: AND a.resource_id = b_resource_id
1949: AND r.user_id = a.created_by;
1950:

Line 2126: , jtf_task_all_assignments asg

2122: AND fg.grantee_type = 'USER'
2123: AND fg.instance_pk2_value = 'RS_GROUP'
2124: AND fg.instance_pk1_value = to_char(g.group_id)
2125: ) rs
2126: , jtf_task_all_assignments asg
2127: , jtf_tasks_b tsk
2128: WHERE asg.resource_type_code = rs.resource_type_code
2129: AND asg.resource_id = rs.resource_id
2130: AND asg.task_id = tsk.task_id

Line 2266: jtf_task_all_assignments ta,

2262: FROM jtf_task_recur_rules rc,
2263: jtf_task_statuses_b ts,
2264: jtf_task_priorities_b tb,
2265: jtf_tasks_tl tl,
2266: jtf_task_all_assignments ta,
2267: jtf_tasks_b t
2268: WHERE
2269: ta.task_id = t.task_id
2270: and ta.assignee_role= b_role

Line 2838: from jtf_task_all_assignments table and the user has the option of Accepting the declined

2834: x_data(i).eventtype := g_delete;
2835: x_data(i).resultid := 0;
2836:
2837: /* Commented this for bug#5191856 bcos for deleted appointments, records are not deleted
2838: from jtf_task_all_assignments table and the user has the option of Accepting the declined
2839: Appointment. */
2840: /*cac_sync_task_map_pkg.delete_row (
2841: p_task_sync_id => rec_delete.task_sync_id
2842: );*/

Line 3821: jtf_task_all_assignments ta,

3817: FROM jtf_task_recur_rules rc,
3818: jtf_task_statuses_b ts,
3819: jtf_task_priorities_b tb,
3820: jtf_tasks_tl tl,
3821: jtf_task_all_assignments ta,
3822: jtf_tasks_b t
3823: WHERE
3824:
3825: ta.task_id = t.task_id

Line 5538: from jtf_tasks_b b, jtf_task_all_assignments a, jta_sync_Task_mapping s

5534:
5535: CURSOR check_appt(b_resource_id NUMBER, b_resource_type_code VARCHAR2)
5536: IS
5537: SELECT a.assignment_status_id
5538: from jtf_tasks_b b, jtf_task_all_assignments a, jta_sync_Task_mapping s
5539: where b.task_id = a.task_id
5540: and s.task_id = b.task_id
5541: and s.task_sync_id = p_task_sync_id
5542: and a.resource_id = b_resource_id