APPS.CSF_ALERTS_PUB dependencies on JTF_TASK_STATUSES_B

Line 68: jtf_task_statuses_b

64: and jta.assignment_status_id in (
65: select
66: task_status_id
67: from
68: jtf_task_statuses_b
69: where
70: usage = 'TASK'
71: and nvl(assigned_flag, 'N') = 'Y'
72: and nvl(assignment_status_flag, 'N') = 'Y'

Line 138: jtf_task_statuses_b

134: cursor c_check_task_status_id (v_new_status_id number, v_old_status_id number) is
135: select 'TRUE' from dual where v_old_status_id in (select
136: task_status_id
137: from
138: jtf_task_statuses_b
139: where
140: usage = 'TASK'
141: and nvl(assigned_flag, 'N') <> 'Y'
142: and nvl(assignment_status_flag, 'N') = 'Y'

Line 148: jtf_task_statuses_b

144: and nvl(end_date_active, sysdate + 1))
145: and v_new_status_id in (select
146: task_status_id
147: from
148: jtf_task_statuses_b
149: where
150: usage = 'TASK'
151: and nvl(assigned_flag, 'N') = 'Y'
152: and nvl(assignment_status_flag, 'N') = 'Y'

Line 916: jtf_task_statuses_b

912: and jta.assignment_status_id in (
913: select
914: task_status_id
915: from
916: jtf_task_statuses_b
917: where
918: usage = 'TASK'
919: and nvl(assigned_flag, 'N') = 'Y'
920: and nvl(assignment_status_flag, 'N') = 'Y'