APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on ASG_USER_PUB_RESPS

Line 483: asg_user_pub_resps aupr,

479: jt.address_id,
480: csi.org_id
481: FROM JTF_TASK_ASSIGNMENTS jta,
482: asg_user au,
483: asg_user_pub_resps aupr,
484: jtf_tasks_b jt,
485: cs_incidents_all_b csi,
486: hz_party_sites hz_ps
487: WHERE jta.task_assignment_id = p_taskassgid

Line 516: asg_user_pub_resps aupr,

512: jt.address_id,
513: csi.org_id
514: FROM JTF_TASK_ASSIGNMENTS jta,
515: asg_user au,
516: asg_user_pub_resps aupr,
517: jtf_tasks_b jt,
518: cs_incidents_all_b csi,
519: hz_locations lc
520: WHERE jta.task_assignment_id = p_taskassgid

Line 549: asg_user_pub_resps aupr,

545: jt.address_id,
546: to_number(NULL)
547: FROM JTF_TASK_ASSIGNMENTS jta,
548: asg_user au,
549: asg_user_pub_resps aupr,
550: jtf_tasks_b jt
551: WHERE jta.task_assignment_id = p_taskassgid
552: AND jta.assignee_role = 'ASSIGNEE'
553: AND au.resource_id = jta.resource_id

Line 970: asg_user_pub_resps aupr,

966: csi.org_id
967: FROM csm_task_assignments_acc acc,
968: jtf_task_assignments jta,
969: asg_user au,
970: asg_user_pub_resps aupr,
971: jtf_tasks_b jt,
972: cs_incidents_all_b csi,
973: hz_party_sites hz_ps
974: WHERE acc.task_assignment_id = p_task_assignment_id

Line 1004: asg_user_pub_resps aupr,

1000: csi.org_id
1001: FROM csm_task_assignments_acc acc,
1002: jtf_task_assignments jta,
1003: asg_user au,
1004: asg_user_pub_resps aupr,
1005: jtf_tasks_b jt,
1006: cs_incidents_all_b csi,
1007: hz_locations lc
1008: WHERE acc.task_assignment_id = p_task_assignment_id

Line 1038: asg_user_pub_resps aupr,

1034: TO_NUMBER(NULL)
1035: FROM csm_task_assignments_acc acc,
1036: JTF_TASK_ASSIGNMENTS jta,
1037: asg_user au,
1038: asg_user_pub_resps aupr,
1039: jtf_tasks_b jt
1040: WHERE acc.task_assignment_id = p_task_assignment_id
1041: AND acc.task_assignment_id = jta.task_assignment_id
1042: AND acc.user_id = au.user_id