APPS.AR_CMGT_DATA_POINTS_PKG dependencies on HZ_CONTACT_POINTS

Line 4261: l_contact_point_id hz_contact_points.contact_point_id%TYPE;

4257: p_error_msg OUT nocopy VARCHAR2) IS
4258:
4259: l_organization_profile_id hz_organization_profiles.organization_profile_id%TYPE;
4260: l_location_id hz_locations.location_id%TYPE;
4261: l_contact_point_id hz_contact_points.contact_point_id%TYPE;
4262: l_relationship_id hz_relationships.relationship_id%TYPE;
4263: l_report_type hz_financial_reports.type_of_financial_report%TYPE := 'BALANCE_SHEET';
4264: l_credit_rating_id NUMBER;
4265: l_financial_report_id NUMBER;

Line 4286: FROM hz_contact_points

4282: AND rel.object_table_name = 'HZ_PARTIES';
4283:
4284: CURSOR c_contact_point IS
4285: SELECT contact_point_id, phone_line_type
4286: FROM hz_contact_points
4287: WHERE owner_table_name = 'HZ_PARTIES'
4288: AND owner_table_id = p_party_id
4289: AND contact_point_type = 'PHONE'
4290: AND actual_content_source = 'DNB'

Line 4401: p_source_table_name => 'HZ_CONTACT_POINTS',

4397: LOOP
4398:
4399: populate_dnb_data(
4400: p_case_folder_id => p_case_folder_id,
4401: p_source_table_name => 'HZ_CONTACT_POINTS',
4402: p_source_key => c_contact_point_rec.contact_point_id,
4403: p_source_key_column_name => 'CONTACT_POINT_ID',
4404: p_mode => p_mode,
4405: p_source_key_type => c_contact_point_rec.phone_line_type,