APPS.AR_CMGT_DATA_POINTS_PKG dependencies on HZ_CONTACT_POINTS

Line 4410: l_contact_point_id hz_contact_points.contact_point_id%TYPE;

4406: p_error_msg OUT nocopy VARCHAR2) IS
4407:
4408: l_organization_profile_id hz_organization_profiles.organization_profile_id%TYPE;
4409: l_location_id hz_locations.location_id%TYPE;
4410: l_contact_point_id hz_contact_points.contact_point_id%TYPE;
4411: l_relationship_id hz_relationships.relationship_id%TYPE;
4412: l_report_type hz_financial_reports.type_of_financial_report%TYPE := 'BALANCE_SHEET';
4413: l_credit_rating_id NUMBER;
4414: l_financial_report_id NUMBER;

Line 4435: FROM hz_contact_points

4431: AND rel.object_table_name = 'HZ_PARTIES';
4432:
4433: CURSOR c_contact_point IS
4434: SELECT contact_point_id, phone_line_type
4435: FROM hz_contact_points
4436: WHERE owner_table_name = 'HZ_PARTIES'
4437: AND owner_table_id = p_party_id
4438: AND contact_point_type = 'PHONE'
4439: AND actual_content_source = 'DNB'

Line 4550: p_source_table_name => 'HZ_CONTACT_POINTS',

4546: LOOP
4547:
4548: populate_dnb_data(
4549: p_case_folder_id => p_case_folder_id,
4550: p_source_table_name => 'HZ_CONTACT_POINTS',
4551: p_source_key => c_contact_point_rec.contact_point_id,
4552: p_source_key_column_name => 'CONTACT_POINT_ID',
4553: p_mode => p_mode,
4554: p_source_key_type => c_contact_point_rec.phone_line_type,