APPS.CSL_JTF_TASK_REFS_ACC_PKG dependencies on JTF_TASK_REFERENCES_B

Line 8: g_table_name CONSTANT VARCHAR2(30) := 'JTF_TASK_REFERENCES_B';

4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_JTF_TASK_REFERENCES_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('JTF_TASK_REFERENCES');
8: g_table_name CONSTANT VARCHAR2(30) := 'JTF_TASK_REFERENCES_B';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'TASK_REFERENCE_ID';
10: g_debug_level NUMBER; -- debug level
11:
12:

Line 19: jtf_task_references_b jtr,

15: PRAGMA AUTONOMOUS_TRANSACTION;
16: CURSOR c_esc(b_task_id NUMBER, b_resource_id NUMBER, b_last_run_date DATE ) IS
17: SELECT jtr.task_reference_id
18: FROM jtf_tasks_b jtb,
19: jtf_task_references_b jtr,
20: jtf_task_statuses_b jts
21: WHERE jtb.task_id = jtr.task_id
22: AND jtb.task_type_id = 22
23: AND jtb.task_status_id = jts.task_status_id

Line 166: jtf_task_references_b jtr,

162: WHERE resource_id = b_resource_id
163: AND task_reference_id NOT IN(
164: SELECT jtr.task_reference_id
165: FROM jtf_tasks_b jtb,
166: jtf_task_references_b jtr,
167: jtf_task_statuses_b jts
168: WHERE jtb.task_id = jtr.task_id
169: AND jtb.task_type_id = 22
170: AND jtb.task_status_id = jts.task_status_id