DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on HZ_PARTY_SITES

Line 486: hz_party_sites hz_ps

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
488: AND jta.assignee_role = 'ASSIGNEE'
489: AND au.resource_id = jta.resource_id
490: AND au.user_name = aupr.user_name

Line 798: hz_party_sites hz_ps

794: csi.incident_location_type
795: FROM JTF_TASK_ASSIGNMENTS jta,
796: jtf_tasks_b jt,
797: cs_incidents_all_b csi,
798: hz_party_sites hz_ps
799: WHERE jta.task_assignment_id = p_taskassgid
800: AND jt.task_id = jta.task_id
801: AND jt.source_object_type_code = 'SR'
802: AND jt.source_object_id = csi.incident_id

Line 973: hz_party_sites hz_ps

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
975: AND acc.task_assignment_id = jta.task_assignment_id
976: AND acc.user_id = au.user_id
977: AND au.user_name = aupr.user_name

Line 1539: hz_party_sites hz_ps

1535: csi.incident_location_type
1536: FROM JTF_TASK_ASSIGNMENTS jta,
1537: jtf_tasks_b jt,
1538: cs_incidents_all_b csi,
1539: hz_party_sites hz_ps
1540: WHERE jta.task_assignment_id = p_task_assignment_id
1541: AND jt.task_id = jta.task_id
1542: AND jt.source_object_type_code = 'SR'
1543: AND jt.source_object_id = csi.incident_id