APPS.CS_ERES_INT_PKG dependencies on CS_HZ_SR_CONTACT_POINTS

Line 1146: ,cs_hz_sr_contact_points sr_cont

1142: -- :Contact_Type
1143: CURSOR Get_Contact_Type (v_incident_id NUMBER) IS
1144: SELECT cont_type_lkup.meaning
1145: FROM FND_LOOKUP_VALUES cont_type_lkup
1146: ,cs_hz_sr_contact_points sr_cont
1147: WHERE sr_cont.contact_type=cont_type_lkup.lookup_code
1148: AND cont_type_lkup.lookup_type='CS_SR_CONTACT_TYPE'
1149: AND sr_cont.incident_id = v_incident_id
1150: ANd sr_cont.primary_flag = 'Y'

Line 1163: FROM cs_hz_sr_contact_points sr_cont

1159: CURSOR Get_Contact_Name (v_incident_id NUMBER, v_customer_id NUMBER) IS
1160: SELECT CSZ_SERVICEREQUEST_UTIL_PVT.get_contact_name(sr_cont.contact_type,
1161: sr_cont.party_id,
1162: v_customer_id)
1163: FROM cs_hz_sr_contact_points sr_cont
1164: WHERE sr_cont.incident_id = v_incident_id
1165: AND sr_cont.primary_flag = 'Y';
1166:
1167: l_Contact_Name VARCHAR2(360);

Line 1244: cs_hz_sr_contact_points sr_cont,

1240: nvl2(party_cont.phone_country_code, party_cont.phone_country_code || '-',null ) ||
1241: nvl2(party_cont.phone_area_code, party_cont.phone_area_code || '-', null) ||
1242: party_cont.phone_number PHONE_NUMBER
1243: FROM hz_contact_points party_cont,
1244: cs_hz_sr_contact_points sr_cont,
1245: FND_LOOKUP_VALUES ar
1246: WHERE sr_cont.incident_id = v_incident_id
1247: AND sr_cont.contact_point_id = party_cont.contact_point_id
1248: AND sr_cont.contact_type <> 'EMPLOYEE'

Line 1259: FROM cs_hz_sr_contact_points sr_cont,

1255: AND sr_cont.primary_flag='Y'
1256: UNION
1257: SELECT hrl.meaning PHONE_TYPE,
1258: pp.phone_number PHONE_NUMBER
1259: FROM cs_hz_sr_contact_points sr_cont,
1260: per_phones pp,
1261: hr_lookups hrl
1262: WHERE sr_cont.incident_id = v_incident_id
1263: AND sr_cont.contact_type = 'EMPLOYEE'

Line 1278: cs_hz_sr_contact_points sr_cont

1274: --:Contact_Email
1275: CURSOR Get_Contact_Email (v_incident_id NUMBER) IS
1276: SELECT party_cont.email_address EMAIL
1277: FROM hz_contact_points party_cont,
1278: cs_hz_sr_contact_points sr_cont
1279: WHERE sr_cont.incident_id = v_incident_id
1280: AND sr_cont.contact_point_id = party_cont.contact_point_id
1281: AND sr_cont.contact_type <> 'EMPLOYEE'
1282: AND party_cont.contact_point_type = 'EMAIL'

Line 1287: FROM cs_hz_sr_contact_points sr_cont,

1283: AND sr_cont.primary_flag = 'Y'
1284: AND party_cont.email_address is not null
1285: UNION
1286: SELECT pap.email_address EMAIL
1287: FROM cs_hz_sr_contact_points sr_cont,
1288: per_all_people_f pap
1289: WHERE sr_cont.incident_id = v_incident_id
1290: AND sr_cont.contact_type = 'EMPLOYEE'
1291: AND pap.person_id = sr_cont.party_id