DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on PER_PHONES

Line 1260: per_phones pp,

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'
1264: AND pp.phone_id = sr_cont.contact_point_id