APPS.ASP_SERVICE_CONTENT_PROVIDER dependencies on HZ_PARTIES

Line 86: hz_parties p,

82: rs.resource_name as sr_owner,
83: sr_sts.name as sr_status,
84: lk_esc.meaning as esc_level
85: FROM cs_incidents_all_b sr,
86: hz_parties p,
87: jtf_rs_resource_extns_vl rs,
88: cs_incident_statuses_vl sr_sts,
89: jtf_tasks_vl t, jtf_task_references_vl r,fnd_lookups lk_esc
90: WHERE sr.incident_id = c_incident_id