APPS.ZX_TEST_API dependencies on HR_ALL_ORGANIZATION_UNITS

Line 591: l_chrt_acct_id hr_all_organization_units.business_group_id%type;

587: l_number_of_segments NUMBER;
588: l_varchar2_id VARCHAR2(1000);
589: l_varchar2_id1 VARCHAR2(1000);
590: l_num_id NUMBER;
591: l_chrt_acct_id hr_all_organization_units.business_group_id%type;
592: l_table_name zx_party_types.party_source_table%type;
593: l_party_type zx_party_types.party_type_code%type;
594: l_party_number hz_parties.party_number%type;
595: l_name xle_entity_profiles.name%type;

Line 671: from hr_all_organization_units

667: -----------------------------------------
668: BEGIN
669: select organization_id
670: into x_user_key_id
671: from hr_all_organization_units
672: where business_group_id = l_num_id
673: and name = l_varchar2_id;
674: EXCEPTION
675: WHEN NO_DATA_FOUND THEN