APPS.CAC_SYNC_TASK_COMMON dependencies on CAC_SYNC_PRINCIPALS

Line 5241: FROM cac_sync_principals

5237:
5238: CURSOR getUserId(b_principal_id IN NUMBER)
5239: IS
5240: SELECT user_id
5241: FROM cac_sync_principals
5242: WHERE principal_id = b_principal_id;
5243:
5244: CURSOR getBookings(b_principal_id IN NUMBER, b_user_id IN NUMBER)
5245: IS

Line 5250: FROM cac_sync_principals

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
5252: WHERE principal_id = b_principal_id)
5253: AND user_id = b_user_id)
5254: AND jstm.task_id=jtb.task_id

Line 5251: WHERE device_id = (SELECT device_id FROM cac_sync_principals

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
5252: WHERE principal_id = b_principal_id)
5253: AND user_id = b_user_id)
5254: AND jstm.task_id=jtb.task_id
5255: AND jtb.entity IN ('BOOKING', 'APPOINTMENT')