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 931: FROM JTF_TASK_ASSIGNMENTS

927:
928: CURSOR c_task_assignments(b_task_id NUMBER)
929: IS
930: SELECT TASK_ASSIGNMENT_ID,resource_id
931: FROM JTF_TASK_ASSIGNMENTS
932: WHERE TASK_ID=b_task_id;
933:
934: CURSOR c_resource_id(b_user_id NUMBER) IS
935: SELECT RESOURCE_ID

Line 1170: FROM JTF_TASK_ASSIGNMENTS

1166:
1167: CURSOR c_task_assignments(b_task_id NUMBER)
1168: IS
1169: SELECT TASK_ASSIGNMENT_ID,resource_id
1170: FROM JTF_TASK_ASSIGNMENTS
1171: WHERE TASK_ID=b_task_id;
1172:
1173: CURSOR c_resource_id(b_user_id NUMBER) IS
1174: SELECT RESOURCE_ID