APPS.CSC_RESPONSE_CENTER_PKG dependencies on HZ_PARTY_SITES

Line 354: hz_party_sites ps

350: l_phone_extension ,
351: l_full_phone
352: FROM hz_contact_points ph,
353: ar_lookups lkup ,
354: hz_party_sites ps
355: WHERE ph.phone_line_type = lkup.lookup_code
356: AND lkup.lookup_type = 'PHONE_LINE_TYPE'
357: AND lkup.enabled_flag = 'Y'
358: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(lkup.start_date_active, SYSDATE)) AND TRUNC(NVL(lkup.end_date_active,SYSDATE))

Line 362: AND ph.owner_table_name = 'HZ_PARTY_SITES'

358: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(lkup.start_date_active, SYSDATE)) AND TRUNC(NVL(lkup.end_date_active,SYSDATE))
359: AND ph.owner_table_id = p_site_id(i)
360: AND ps.party_site_id = ph.owner_table_id
361: AND ps.party_id = x_Phone_Rec(i).party_id
362: AND ph.owner_table_name = 'HZ_PARTY_SITES'
363: AND ph.contact_point_type = 'PHONE';
364:
365: x_Phone_Rec(i).Phone_Country_Code := l_Phone_Country_Code;
366: x_Phone_Rec(i).Phone_Area_Code := l_Phone_Area_Code;