APPS.AR_CMGT_DATA_POINTS_PKG dependencies on HZ_RELATIONSHIPS

Line 4411: l_relationship_id hz_relationships.relationship_id%TYPE;

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

Line 4423: FROM hz_relationships rel

4419: l_annual_sales_volume_id NUMBER;
4420:
4421: CURSOR c_relationships IS
4422: SELECT rel.relationship_id, rel.relationship_code
4423: FROM hz_relationships rel
4424: WHERE rel.object_id = p_party_id
4425: AND rel.relationship_code in ('HEADQUARTERS_OF','PARENT_OF',
4426: 'DOMESTIC_ULTIMATE_OF','GLOBAL_ULTIMATE_OF')
4427: AND rel.actual_content_source = 'DNB'

Line 4646: p_source_table_name => 'HZ_RELATIONSHIPS',

4642: FOR c_relationship_rec IN c_relationships
4643: LOOP
4644: populate_dnb_data(
4645: p_case_folder_id => p_case_folder_id,
4646: p_source_table_name => 'HZ_RELATIONSHIPS',
4647: p_source_key => c_relationship_rec.relationship_id,
4648: p_source_key_column_name => 'RELATIONSHIP_ID',
4649: p_mode => p_mode,
4650: p_source_key_type => c_relationship_rec.relationship_code,