DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on HZ_PARTY_SITES

Line 481: hz_party_sites hz_ps

477: asg_user au,
478: asg_user_pub_resps aupr,
479: jtf_tasks_b jt,
480: cs_incidents_all_b csi,
481: hz_party_sites hz_ps
482: WHERE jta.task_assignment_id = p_taskassgid
483: AND jta.assignee_role = 'ASSIGNEE'
484: AND au.resource_id = jta.resource_id
485: AND au.user_name = aupr.user_name

Line 756: hz_party_sites hz_ps

752: csi.incident_location_type
753: FROM JTF_TASK_ASSIGNMENTS jta,
754: jtf_tasks_b jt,
755: cs_incidents_all_b csi,
756: hz_party_sites hz_ps
757: WHERE jta.task_assignment_id = p_taskassgid
758: AND jt.task_id = jta.task_id
759: AND jt.source_object_type_code = 'SR'
760: AND jt.source_object_id = csi.incident_id

Line 929: hz_party_sites hz_ps

925: asg_user au,
926: asg_user_pub_resps aupr,
927: jtf_tasks_b jt,
928: cs_incidents_all_b csi,
929: hz_party_sites hz_ps
930: WHERE acc.task_assignment_id = p_task_assignment_id
931: AND acc.task_assignment_id = jta.task_assignment_id
932: AND acc.user_id = au.user_id
933: AND au.user_name = aupr.user_name

Line 1467: hz_party_sites hz_ps

1463: csi.incident_location_type
1464: FROM JTF_TASK_ASSIGNMENTS jta,
1465: jtf_tasks_b jt,
1466: cs_incidents_all_b csi,
1467: hz_party_sites hz_ps
1468: WHERE jta.task_assignment_id = p_task_assignment_id
1469: AND jt.task_id = jta.task_id
1470: AND jt.source_object_type_code = 'SR'
1471: AND jt.source_object_id = csi.incident_id