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 1198: from cs_hz_sr_contact_points sr_cont

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

Line 1452: from cs_hz_sr_contact_points cp, CS_PARTY_ROLES_VL partyrole

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

Line 1473: from cs_hz_sr_contact_points cp, CS_PARTY_ROLES_VL partyrole

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