APPS.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on CS_HZ_SR_CONTACT_POINTS

Line 772: from cs_hz_sr_contact_points

768: l_contact_type VARCHAR2(400) default null;
769: l_contact_name VARCHAR2(4000) default null;
770: cursor cont(param_incident_id NUMBER,param_primary_flag VARCHAR2) is
771: select contact_type, party_id
772: from cs_hz_sr_contact_points
773: where incident_id = param_incident_id and primary_flag = param_primary_flag and
774: rownum < 2 order by party_id;
775: begin
776: -- If contact partyid is absent then find the contact based on incident info

Line 1199: from cs_hz_sr_contact_points sr_cont

1195:
1196: cursor c_sr_cont is
1197: select sr_cont.party_id,
1198: sr_cont.contact_type
1199: from cs_hz_sr_contact_points sr_cont
1200: where sr_cont.incident_id = p_incident_id
1201: and sr_cont.primary_flag = 'Y';
1202:
1203: cursor c_emp(param_party_contact_id NUMBER) is

Line 1453: from cs_hz_sr_contact_points cp, CS_PARTY_ROLES_VL partyrole

1449: l_concat_party_role_names varchar2(360) DEFAULT NULL;
1450: -- Person cursor
1451: cursor personCursor(p_incident_id NUMBER, p_party_id NUMBER) is
1452: select distinct partyrole.name
1453: from cs_hz_sr_contact_points cp, CS_PARTY_ROLES_VL partyrole
1454: where cp.party_role_code = partyrole.party_role_code
1455: and cp.incident_id = p_incident_id
1456: and
1457: (

Line 1474: from cs_hz_sr_contact_points cp, CS_PARTY_ROLES_VL partyrole

1470: cursor OrgEmpRelationshipCursor(p_incident_id NUMBER,
1471: p_party_id NUMBER,
1472: p_party_type VARCHAR2) is
1473: select distinct partyrole.name
1474: from cs_hz_sr_contact_points cp, CS_PARTY_ROLES_VL partyrole
1475: where cp.party_role_code = partyrole.party_role_code
1476: and cp.incident_id = p_incident_id
1477: and
1478: (