APPS.JTA_SYNC_TASK_CURSORS dependencies on JTA_SYNC_TASK_COMMON

Line 121: NVL (t.timezone_id, jta_sync_task_common.g_client_timezone_id) timezone_id,

117: t.alarm_start,
118: UPPER (t.alarm_start_uom) alarm_start_uom,
119: NVL (t.private_flag, 'N') private_flag,
120: t.deleted_flag,
121: NVL (t.timezone_id, jta_sync_task_common.g_client_timezone_id) timezone_id,
122: t.task_id,
123: t.owner_type_code,
124: t.source_object_type_code,
125: rc.recurrence_rule_id,

Line 214: NVL (t.timezone_id, jta_sync_task_common.g_client_timezone_id) timezone_id,

210: t.alarm_start,
211: UPPER (t.alarm_start_uom) alarm_start_uom,
212: NVL (t.private_flag, 'N') private_flag,
213: t.deleted_flag,
214: NVL (t.timezone_id, jta_sync_task_common.g_client_timezone_id) timezone_id,
215: tm.task_sync_id,
216: t.task_id,
217: t.owner_type_code,
218: t.source_object_type_code,

Line 408: NVL (t.timezone_id, jta_sync_task_common.g_client_timezone_id) timezone_id,

404: t.alarm_start,
405: UPPER (t.alarm_start_uom) alarm_start_uom,
406: NVL (t.private_flag, 'N') private_flag,
407: t.deleted_flag,
408: NVL (t.timezone_id, jta_sync_task_common.g_client_timezone_id) timezone_id,
409: t.task_id,
410: t.owner_type_code,
411: t.source_object_type_code,
412: t.recurrence_rule_id,

Line 474: NVL (t.timezone_id, jta_sync_task_common.g_client_timezone_id) timezone_id,

470: t.alarm_start,
471: UPPER (t.alarm_start_uom) alarm_start_uom,
472: NVL (t.private_flag, 'N') private_flag,
473: t.deleted_flag,
474: NVL (t.timezone_id, jta_sync_task_common.g_client_timezone_id) timezone_id,
475: tm.task_sync_id,
476: t.task_id,
477: t.owner_type_code,
478: t.source_object_type_code,

Line 527: AND b.source_object_type_code = jta_sync_task_common.G_APPOINTMENT

523: WHERE b.task_id = m.task_id
524: AND m.resource_id = jta_sync_task.g_login_resource_id
525: AND NVL (b.deleted_flag, 'N') = 'N'
526: AND b.owner_type_code ='RS_GROUP'
527: AND b.source_object_type_code = jta_sync_task_common.G_APPOINTMENT
528: AND b_resource_id = m.resource_id
529: AND b_source_object_type = jta_sync_task_common.G_APPOINTMENT
530: AND b_resource_type = 'RS_EMPLOYEE'
531: AND NOT EXISTS

Line 529: AND b_source_object_type = jta_sync_task_common.G_APPOINTMENT

525: AND NVL (b.deleted_flag, 'N') = 'N'
526: AND b.owner_type_code ='RS_GROUP'
527: AND b.source_object_type_code = jta_sync_task_common.G_APPOINTMENT
528: AND b_resource_id = m.resource_id
529: AND b_source_object_type = jta_sync_task_common.G_APPOINTMENT
530: AND b_resource_type = 'RS_EMPLOYEE'
531: AND NOT EXISTS
532: (SELECT 1
533: FROM fnd_grants g