APPS.CAC_SYNC_TASK_COMMON dependencies on CAC_VIEW_COLLAB_DETAILS_VL

Line 267: FROM CAC_VIEW_COLLAB_DETAILS_VL

263: is
264: CURSOR getCollabDetails(b_task_id NUMBER) IS
265: SELECT COLLAB_ID, MEETING_MODE,MEETING_ID,MEETING_URL,JOIN_URL ,
266: PLAYBACK_URL ,DOWNLOAD_URL ,CHAT_URL ,IS_STANDALONE_LOCATION,DIAL_IN
267: FROM CAC_VIEW_COLLAB_DETAILS_VL
268: WHERE task_id=b_task_id;
269:
270: l_collab_details getCollabDetails%ROWTYPE;
271:

Line 3299: FROM CAC_VIEW_COLLAB_DETAILS_VL

3295:
3296: CURSOR getCollabDetails(b_task_id NUMBER) IS
3297: SELECT COLLAB_ID, MEETING_MODE,MEETING_ID,MEETING_URL,JOIN_URL ,
3298: PLAYBACK_URL ,DOWNLOAD_URL ,CHAT_URL ,IS_STANDALONE_LOCATION,DIAL_IN
3299: FROM CAC_VIEW_COLLAB_DETAILS_VL
3300: WHERE task_id=b_task_id;
3301: l_collab_details getCollabDetails%ROWTYPE;
3302:
3303: Dates VARCHAR2(4000);

Line 4079: from cac_view_collab_details_vl cac, jtf_tasks_b jtb1,jtf_tasks_b jtb2

4075: cursor getTaskForRecurRule(b_task_id number) is
4076: select CAC.COLLAB_ID, CAC.MEETING_MODE,CAC.MEETING_ID,CAC.MEETING_URL,
4077: CAC.JOIN_URL ,CAC.PLAYBACK_URL ,CAC.DOWNLOAD_URL ,CAC.CHAT_URL ,
4078: CAC.IS_STANDALONE_LOCATION,CAC.DIAL_IN, jtb1.task_id
4079: from cac_view_collab_details_vl cac, jtf_tasks_b jtb1,jtf_tasks_b jtb2
4080: where cac.task_id=jtb1.task_id
4081: and jtb1.recurrence_rule_id=jtb2.recurrence_rule_id
4082: and jtb2.task_id=b_task_id;
4083:

Line 4090: from CAC_VIEW_COLLAB_DETAILS_VL

4086:
4087: cursor getCollabDetails(b_task_id NUMBER) is
4088: select COLLAB_ID, MEETING_MODE,MEETING_ID,MEETING_URL,JOIN_URL ,
4089: PLAYBACK_URL ,DOWNLOAD_URL ,CHAT_URL ,IS_STANDALONE_LOCATION,DIAL_IN
4090: from CAC_VIEW_COLLAB_DETAILS_VL
4091: where task_id=b_task_id;
4092: l_collab_details getCollabDetails%rowtype;
4093: l_priorityId jtf_tasks_b.task_priority_id%type;
4094: