APPS.CAC_VIEW_WF_PVT dependencies on JTF_TASKS_B

Line 1486: FROM jtf_tasks_b jtb

1482: , jtb.task_type_id TYPE_ID
1483: , jtb.task_priority_id PRIORITY_ID
1484: , (jtb.calendar_end_date - jtb.calendar_start_date)*24*60 DURATION
1485: , jtb.timezone_id TIMEZONE_ID
1486: FROM jtf_tasks_b jtb
1487: , jtf_tasks_tl jtl
1488: , jtf_task_all_assignments jta
1489: WHERE jtb.task_id = jtl.task_id
1490: AND jtl.language = userenv('LANG')

Line 1733: FROM jtf_tasks_b jtb

1729: , jtb.task_type_id TYPE_ID
1730: , jtb.task_priority_id PRIORITY_ID
1731: , (jtb.calendar_end_date - jtb.calendar_start_date)*24*60 DURATION
1732: , jtb.timezone_id TIMEZONE_ID
1733: FROM jtf_tasks_b jtb
1734: , jtf_tasks_tl jtl
1735: , jtf_task_all_assignments jta
1736: WHERE jtb.task_id = jtl.task_id
1737: AND jtl.language = userenv('LANG')

Line 2465: FROM jtf_tasks_b jtb

2461: ,(NVL( FND_PROFILE.Value('SERVER_TIMEZONE_ID')
2462: , 4)
2463: )
2464: ) SourceTimezoneID
2465: FROM jtf_tasks_b jtb
2466: , jtf_tasks_tl jtl
2467: , jtf_task_all_assignments jta
2468: WHERE jtb.task_id = jtl.task_id
2469: AND jtl.language = userenv('LANG')

Line 2698: FROM jtf_tasks_b jtb

2694: , jtl.task_name TASK_NAME
2695: , jtl.description TASK_DESCRIPTION
2696: , jtb.calendar_start_date START_DATE
2697: , jtb.calendar_end_date END_DATE
2698: FROM jtf_tasks_b jtb
2699: , jtf_tasks_tl jtl
2700: , jtf_task_all_assignments jta
2701: WHERE jtb.task_id = jtl.task_id
2702: AND jtl.language = userenv('LANG')

Line 2917: FROM jtf_tasks_b jtb

2913: , jtb.task_type_id TYPE_ID
2914: , jtb.task_priority_id PRIORITY_ID
2915: , (jtb.calendar_end_date - jtb.calendar_start_date)*24*60 DURATION
2916: , jtb.timezone_id TIMEZONE_ID
2917: FROM jtf_tasks_b jtb
2918: , jtf_tasks_tl jtl
2919: , jtf_task_all_assignments jta
2920: WHERE jtb.task_id = jtl.task_id
2921: AND jtl.language = userenv('LANG')

Line 3376: FROM jtf_tasks_b jtb

3372: , jtb.task_type_id TYPE_ID
3373: , jtb.task_priority_id PRIORITY_ID
3374: , (jtb.calendar_end_date - jtb.calendar_start_date)*24*60 DURATION
3375: , jtb.timezone_id TIMEZONE_ID
3376: FROM jtf_tasks_b jtb
3377: , jtf_tasks_tl jtl
3378: , jtf_task_all_assignments jta
3379: WHERE jtb.task_id = jtl.task_id
3380: AND jtl.language = userenv('LANG')

Line 3652: , jtf_tasks_b jtb

3648: , jtr.saturday
3649: , jtb.timezone_id
3650: , (jtb.calendar_end_date - jtb.calendar_start_date)*24*60 duration
3651: FROM jtf_task_recur_rules jtr
3652: , jtf_tasks_b jtb
3653: WHERE jtb.recurrence_rule_id = jtr.recurrence_rule_id
3654: AND jtb.task_id = b_task_id;
3655:
3656: r_rule c_rule%ROWTYPE;