APPS.CAC_SYNC_TASK_COMMON dependencies on JTA_SYNC_TASK_MAPPING_S

Line 854: SELECT jta_sync_task_mapping_s.nextval

850: IF (p_operation = g_new)
851: THEN
852: IF (x_task_sync_id IS NULL) OR (x_task_sync_id <= 0)
853: THEN
854: SELECT jta_sync_task_mapping_s.nextval
855: INTO x_task_sync_id
856: FROM dual;
857: END IF;
858:

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