APPS.CAC_SYNC_TASK_COMMON dependencies on JTA_SYNC_TASK_MAPPING

Line 435: FROM jta_sync_task_mapping

431: IS
432: CURSOR c_synctask
433: IS
434: SELECT task_id
435: FROM jta_sync_task_mapping
436: WHERE task_sync_id = p_sync_id;
437:
438: l_task_id NUMBER;
439: BEGIN

Line 621: FROM jta_sync_task_mapping

617: IS
618: CURSOR c_task_sync
619: IS
620: SELECT task_id
621: FROM jta_sync_task_mapping
622: WHERE task_sync_id = p_sync_id;
623:
624: l_task_id NUMBER;
625: BEGIN

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 3291: select 1 from jta_sync_task_mapping where

3287:
3288:
3289: cursor syncIDExists(b_principal_id NUMBER,b_task_id NUMBER,b_resource_id NUMBER)
3290: is
3291: select 1 from jta_sync_task_mapping where
3292: principal_id=b_principal_id
3293: and task_id=b_task_id
3294: and resource_id=b_resource_id;
3295:

Line 5159: FROM jta_sync_task_mapping

5155: RETURN BOOLEAN
5156: IS
5157: CURSOR c_mapping (b_syncid NUMBER) IS
5158: SELECT 1
5159: FROM jta_sync_task_mapping
5160: WHERE task_sync_id = b_syncid;
5161:
5162: l_dummy NUMBER;
5163: l_valid BOOLEAN := TRUE;

Line 5247: FROM jta_sync_task_mapping jstm, jtf_tasks_b jtb

5243:
5244: CURSOR getBookings(b_principal_id IN NUMBER, b_user_id IN NUMBER)
5245: IS
5246: SELECT jtb.task_id,jtb.object_version_number,jstm.task_sync_id, jtb.source_object_type_code objectcode
5247: FROM jta_sync_task_mapping jstm, jtf_tasks_b jtb
5248: WHERE jstm.principal_id IN
5249: (SELECT principal_id
5250: FROM cac_sync_principals
5251: WHERE device_id = (SELECT device_id FROM cac_sync_principals

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