APPS.JTA_SYNC_TASK_COMMON dependencies on JTF_TASKS_B

Line 381: FROM jtf_tasks_b

377: l_count NUMBER;
378: BEGIN
379: SELECT COUNT (recurrence_rule_id)
380: INTO l_count
381: FROM jtf_tasks_b
382: WHERE recurrence_rule_id = p_recurrence_rule_id;
383: RETURN l_count;
384: END count_excluded_tasks;
385:

Line 432: FROM jtf_tasks_b

428: CURSOR c_recur_tasks (b_recurrence_rule_id NUMBER,
429: b_exclusion_start_date DATE)
430: IS
431: SELECT task_id
432: FROM jtf_tasks_b
433: WHERE recurrence_rule_id = b_recurrence_rule_id
434: AND TRUNC (calendar_start_date) = TRUNC (b_exclusion_start_date);
435:
436: l_task_id NUMBER;

Line 478: FROM jtf_tasks_b jt

474:
475: CURSOR c_dateselect
476: IS
477: SELECT jt.date_selected
478: FROM jtf_tasks_b jt
479: WHERE jt.task_id = p_task_id;
480: --check for alarm flag
481:
482: BEGIN

Line 605: FROM jtf_tasks_b

601: IS
602: CURSOR c_task_timezone
603: IS
604: SELECT timezone_id
605: FROM jtf_tasks_b
606: WHERE task_id = p_task_id;
607:
608: l_task_timezone_id NUMBER;
609: BEGIN

Line 645: FROM jtf_tasks_b

641: IS
642: CURSOR c_tasks_ovn (b_task_id NUMBER)
643: IS
644: SELECT object_version_number
645: FROM jtf_tasks_b
646: WHERE task_id = b_task_id;
647:
648: l_object_version_number NUMBER;
649: BEGIN

Line 1115: FROM jtf_tasks_b

1111: IS
1112: CURSOR c_recur_tasks
1113: IS
1114: SELECT MAX (calendar_end_date)
1115: FROM jtf_tasks_b
1116: WHERE recurrence_rule_id = p_recurrence_rule_id;
1117:
1118: l_date DATE;
1119: BEGIN

Line 1733: FROM jtf_tasks_b

1729: IS
1730: CURSOR c_source (b_task_id NUMBER)
1731: IS
1732: SELECT source_object_type_code
1733: FROM jtf_tasks_b
1734: WHERE task_id = b_task_id;
1735:
1736: l_source_object_type_code VARCHAR2(60);
1737: BEGIN

Line 1802: , jtf_tasks_b tsk

1798: AND fg.instance_pk2_value = 'RS_GROUP'
1799: AND fg.instance_pk1_value = to_char(g.group_id)
1800: ) rs
1801: , jtf_task_all_assignments asg
1802: , jtf_tasks_b tsk
1803: WHERE asg.resource_type_code = rs.resource_type_code
1804: AND asg.resource_id = rs.resource_id
1805: AND asg.task_id = tsk.task_id
1806: AND tsk.task_id = p_task_id

Line 1896: FROM jtf_tasks_b t

1892: IS
1893: CURSOR c_recur
1894: IS
1895: SELECT t.recurrence_rule_id
1896: FROM jtf_tasks_b t
1897: WHERE t.task_id = p_task_id;
1898:
1899: l_recurrence_rule_id NUMBER;
1900: BEGIN

Line 2806: FROM jtf_tasks_b

2802: actual_start_date,
2803: actual_end_date,
2804: calendar_start_date,
2805: timezone_id
2806: FROM jtf_tasks_b
2807: WHERE recurrence_rule_id = b_recurrence_rule_id;
2808:
2809: l_changed_rule boolean ;
2810: l_status_id number;

Line 3195: -- FROM jtf_tasks_b

3191:
3192: --CURSOR c_tasks (b_recurrence_rule_id NUMBER, b_task_id NUMBER)
3193: --IS
3194: -- SELECT task_id, source_object_type_code
3195: -- FROM jtf_tasks_b
3196: -- WHERE ( b_recurrence_rule_id IS NOT NULL
3197: -- AND recurrence_rule_id = b_recurrence_rule_id)
3198: -- OR ( b_recurrence_rule_id IS NULL
3199: -- AND task_id = b_task_id);

Line 3263: FROM jtf_task_recur_rules jtrr, jtf_tasks_b jtb

3259: IS
3260: CURSOR c_task_recur (b_task_id NUMBER)
3261: IS
3262: SELECT jtrr.*
3263: FROM jtf_task_recur_rules jtrr, jtf_tasks_b jtb
3264: WHERE jtb.task_id = b_task_id
3265: AND jtb.recurrence_rule_id IS NOT NULL
3266: AND jtrr.recurrence_rule_id = jtb.recurrence_rule_id;
3267: