DBA Data[Home] [Help]

APPS.POS_SUPPLIER_BO_DEP_PKG dependencies on HZ_ORGANIZATION_PROFILES

Line 546: FROM hz_organization_profiles pro,

542: p_organization_id) AS
543: hz_financial_prof_obj_tbl),
544: hz_contact_pref_obj_tbl(),
545: hz_party_usage_obj_tbl())
546: FROM hz_organization_profiles pro,
547: hz_parties p
548: WHERE pro.party_id = p.party_id
549: AND pro.party_id = p_organization_id
550: AND SYSDATE BETWEEN effective_start_date AND

Line 555: FROM hz_organization_profiles

551: nvl(effective_end_date, SYSDATE);
552:
553: CURSOR get_profile_id_csr IS
554: SELECT organization_profile_id
555: FROM hz_organization_profiles
556: WHERE party_id = p_organization_id
557: AND SYSDATE BETWEEN effective_start_date AND
558: nvl(effective_end_date, SYSDATE);
559:

Line 604: p_ext_object_name => 'HZ_ORGANIZATION_PROFILES',

600: CLOSE get_profile_id_csr;
601:
602: hz_extract_ext_attri_bo_pvt.get_ext_attribute_bos(p_init_msg_list => fnd_api.g_false,
603: p_ext_object_id => l_prof_id,
604: p_ext_object_name => 'HZ_ORGANIZATION_PROFILES',
605: p_action_type => p_action_type,
606: x_ext_attribute_objs => x_organization_obj.ext_attributes_objs,
607: x_return_status => x_return_status,
608: x_msg_count => x_msg_count,