APPS.JTF_CAL_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 2462: FROM jtf_tasks_b jtb

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

Line 2695: FROM jtf_tasks_b jtb

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

Line 3046: , jtf_tasks_b jtb

3042: , jtr.saturday
3043: , jtb.timezone_id
3044: , (jtb.calendar_end_date - jtb.calendar_start_date)*24*60 duration
3045: FROM jtf_task_recur_rules jtr
3046: , jtf_tasks_b jtb
3047: WHERE jtb.recurrence_rule_id = jtr.recurrence_rule_id
3048: AND jtb.task_id = b_task_id;
3049:
3050: r_rule c_rule%ROWTYPE;