DBA Data[Home] [Help]

APPS.HZ_DNBUI_PVT dependencies on HZ_ORGANIZATION_PROFILES

Line 585: from hz_organization_profiles

581: BEGIN
582:
583: BEGIN
584: select displayed_duns_party_id into l_displayed_duns_party_id
585: from hz_organization_profiles
586: where party_id = p_party_id and
587: effective_end_date is null
588: and actual_content_source = 'DNB';
589: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 662: from hz_organization_profiles

658:
659: BEGIN
660: BEGIN
661: select displayed_duns_party_id into l_displayed_duns_party_id
662: from hz_organization_profiles
663: where party_id = p_party_id and effective_end_date is null and actual_content_source = 'DNB';
664: EXCEPTION WHEN NO_DATA_FOUND THEN
665: null;
666: END;

Line 721: from hz_organization_profiles

717: IF p_actual_content_source = 'DNB' THEN
718:
719: BEGIN
720: select displayed_duns_party_id into l_displayed_duns_party_id
721: from hz_organization_profiles
722: where party_id = p_party_id and
723: effective_end_date is null and
724: actual_content_source = 'DNB';
725: EXCEPTION WHEN NO_DATA_FOUND THEN