APPS.CS_ERES_INT_PKG dependencies on CS_HZ_SR_CONTACT_POINTS

Line 1217: ,cs_hz_sr_contact_points sr_cont

1213: -- :Contact_Type
1214: CURSOR Get_Contact_Type (v_incident_id NUMBER) IS
1215: SELECT cont_type_lkup.meaning
1216: FROM FND_LOOKUP_VALUES cont_type_lkup
1217: ,cs_hz_sr_contact_points sr_cont
1218: WHERE sr_cont.contact_type=cont_type_lkup.lookup_code
1219: AND cont_type_lkup.lookup_type='CS_SR_CONTACT_TYPE'
1220: AND sr_cont.incident_id = v_incident_id
1221: ANd sr_cont.primary_flag = 'Y'

Line 1234: FROM cs_hz_sr_contact_points sr_cont

1230: CURSOR Get_Contact_Name (v_incident_id NUMBER, v_customer_id NUMBER) IS
1231: SELECT CSZ_SERVICEREQUEST_UTIL_PVT.get_contact_name(sr_cont.contact_type,
1232: sr_cont.party_id,
1233: v_customer_id)
1234: FROM cs_hz_sr_contact_points sr_cont
1235: WHERE sr_cont.incident_id = v_incident_id
1236: AND sr_cont.primary_flag = 'Y';
1237:
1238: l_Contact_Name VARCHAR2(360);

Line 1315: cs_hz_sr_contact_points sr_cont,

1311: nvl2(party_cont.phone_country_code, party_cont.phone_country_code || '-',null ) ||
1312: nvl2(party_cont.phone_area_code, party_cont.phone_area_code || '-', null) ||
1313: party_cont.phone_number PHONE_NUMBER
1314: FROM hz_contact_points party_cont,
1315: cs_hz_sr_contact_points sr_cont,
1316: FND_LOOKUP_VALUES ar
1317: WHERE sr_cont.incident_id = v_incident_id
1318: AND sr_cont.contact_point_id = party_cont.contact_point_id
1319: AND sr_cont.contact_type <> 'EMPLOYEE'

Line 1330: FROM cs_hz_sr_contact_points sr_cont,

1326: AND sr_cont.primary_flag='Y'
1327: UNION
1328: SELECT hrl.meaning PHONE_TYPE,
1329: pp.phone_number PHONE_NUMBER
1330: FROM cs_hz_sr_contact_points sr_cont,
1331: per_phones pp,
1332: hr_lookups hrl
1333: WHERE sr_cont.incident_id = v_incident_id
1334: AND sr_cont.contact_type = 'EMPLOYEE'

Line 1349: cs_hz_sr_contact_points sr_cont

1345: --:Contact_Email
1346: CURSOR Get_Contact_Email (v_incident_id NUMBER) IS
1347: SELECT party_cont.email_address EMAIL
1348: FROM hz_contact_points party_cont,
1349: cs_hz_sr_contact_points sr_cont
1350: WHERE sr_cont.incident_id = v_incident_id
1351: AND sr_cont.contact_point_id = party_cont.contact_point_id
1352: AND sr_cont.contact_type <> 'EMPLOYEE'
1353: AND party_cont.contact_point_type = 'EMAIL'

Line 1358: FROM cs_hz_sr_contact_points sr_cont,

1354: AND sr_cont.primary_flag = 'Y'
1355: AND party_cont.email_address is not null
1356: UNION
1357: SELECT pap.email_address EMAIL
1358: FROM cs_hz_sr_contact_points sr_cont,
1359: per_all_people_f pap
1360: WHERE sr_cont.incident_id = v_incident_id
1361: AND sr_cont.contact_type = 'EMPLOYEE'
1362: AND pap.person_id = sr_cont.party_id