APPS.CSL_JTF_TASK_REFS_ACC_PKG dependencies on JTM_JTF_TASK_REFERENCES_ACC

Line 5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_JTF_TASK_REFERENCES_ACC';

1: PACKAGE BODY CSL_JTF_TASK_REFS_ACC_PKG AS
2: /* $Header: cslteacb.pls 115.6 2002/11/08 14:01:15 asiegers ship $ */
3:
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';

Line 33: FROM jtm_jtf_task_references_acc

29: AND jtb.last_update_date >= NVL(b_last_run_date, jtb.LAST_UPDATE_DATE )
30: AND jtr.object_id = b_task_id
31: AND jtr.task_reference_id NOT IN(
32: SELECT task_reference_id
33: FROM jtm_jtf_task_references_acc
34: WHERE resource_id = b_resource_id );
35: r_esc c_esc%ROWTYPE;
36:
37: CURSOR c_task IS

Line 44: FROM jtm_jtf_task_references_acc;

40: from csl_jtf_tasks_acc;
41:
42: CURSOR c_esc_res IS
43: SELECT DISTINCT resource_id
44: FROM jtm_jtf_task_references_acc;
45:
46: /*** get the last run date of the concurent program ***/
47: CURSOR c_LastRundate
48: IS

Line 161: FROM jtm_jtf_task_references_acc

157: , x_return_status OUT NOCOPY VARCHAR2 )
158: IS
159: CURSOR c_no_esc ( b_resource_id NUMBER ) IS
160: SELECT task_reference_id
161: FROM jtm_jtf_task_references_acc
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,