DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on HR_LOOKUPS

Line 1332: hr_lookups hrl

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'
1335: AND pp.phone_id = sr_cont.contact_point_id
1336: AND pp.parent_table = 'PER_ALL_PEOPLE_F'