APPS.AR_CMGT_DATA_POINTS_PKG dependencies on HZ_RELATIONSHIPS

Line 4262: l_relationship_id hz_relationships.relationship_id%TYPE;

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;
4266: l_hq_branch_ind hz_parties.hq_branch_ind%type;

Line 4274: FROM hz_relationships rel

4270: l_annual_sales_volume_id NUMBER;
4271:
4272: CURSOR c_relationships IS
4273: SELECT rel.relationship_id, rel.relationship_code
4274: FROM hz_relationships rel
4275: WHERE rel.object_id = p_party_id
4276: AND rel.relationship_code in ('HEADQUARTERS_OF','PARENT_OF',
4277: 'DOMESTIC_ULTIMATE_OF','GLOBAL_ULTIMATE_OF')
4278: AND rel.actual_content_source = 'DNB'

Line 4497: p_source_table_name => 'HZ_RELATIONSHIPS',

4493: FOR c_relationship_rec IN c_relationships
4494: LOOP
4495: populate_dnb_data(
4496: p_case_folder_id => p_case_folder_id,
4497: p_source_table_name => 'HZ_RELATIONSHIPS',
4498: p_source_key => c_relationship_rec.relationship_id,
4499: p_source_key_column_name => 'RELATIONSHIP_ID',
4500: p_mode => p_mode,
4501: p_source_key_type => c_relationship_rec.relationship_code,