DBA Data[Home] [Help]

APPS.CSM_SR_EVENT_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 255: FROM jtf_task_assignments jta,

251:
252: CURSOR l_jtf_task_assg_status_csr(p_task_assg_id NUMBER)
253: IS
254: SELECT 1
255: FROM jtf_task_assignments jta,
256: jtf_tasks_b jt,
257: jtf_task_statuses_b jts
258: WHERE jta.task_assignment_id = p_task_assg_id
259: AND jt.task_id = jta.task_id

Line 915: FROM JTF_TASK_ASSIGNMENTS

911:
912: CURSOR c_task_assignments(b_task_id NUMBER)
913: IS
914: SELECT TASK_ASSIGNMENT_ID,resource_id
915: FROM JTF_TASK_ASSIGNMENTS
916: WHERE TASK_ID=b_task_id;
917:
918: CURSOR c_resource_id(b_user_id NUMBER) IS
919: SELECT RESOURCE_ID

Line 1147: FROM JTF_TASK_ASSIGNMENTS

1143:
1144: CURSOR c_task_assignments(b_task_id NUMBER)
1145: IS
1146: SELECT TASK_ASSIGNMENT_ID,resource_id
1147: FROM JTF_TASK_ASSIGNMENTS
1148: WHERE TASK_ID=b_task_id;
1149:
1150: CURSOR c_resource_id(b_user_id NUMBER) IS
1151: SELECT RESOURCE_ID