APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on ASG_USER

Line 306: asg_user au

302: SELECT line.requirement_line_id
303: FROM jtf_task_assignments jta,
304: csp_requirement_headers hdr,
305: csp_requirement_lines line,
306: asg_user au
307: WHERE jta.task_assignment_id = p_task_assg_id
308: AND hdr.task_id = jta.task_id
309: AND line.requirement_header_id = hdr.requirement_header_id
310: AND au.resource_id=jta.resource_id

Line 482: asg_user au,

478: csi.incident_location_type,
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

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 515: asg_user au,

511: csi.incident_location_type,
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

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 548: asg_user au,

544: to_char(NULL),
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'

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 969: asg_user au,

965: jt.ADDRESS_ID,
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

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 1003: asg_user au,

999: jt.ADDRESS_ID,
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

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 1037: asg_user au,

1033: jt.ADDRESS_ID,
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

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