APPS.HZ_MATCH_RULE_48 dependencies on HZ_ORGANIZATION_PROFILES

Line 401: FROM HZ_ORGANIZATION_PROFILES

397: FROM HZ_PARTIES
398: WHERE party_id = p_record_id;
399: IF l_party_type = 'ORGANIZATION' THEN
400: SELECT SIC_CODE INTO l_matched_value
401: FROM HZ_ORGANIZATION_PROFILES
402: WHERE party_id = p_record_id
403: and effective_end_date is null
404: and rownum = 1;
405: ELSIF l_party_type = 'PERSON' THEN

Line 407: FROM HZ_ORGANIZATION_PROFILES

403: and effective_end_date is null
404: and rownum = 1;
405: ELSIF l_party_type = 'PERSON' THEN
406: SELECT SIC_CODE INTO l_matched_value
407: FROM HZ_ORGANIZATION_PROFILES
408: WHERE party_id = p_record_id
409: and rownum = 1;
410: END IF;
411: RETURN l_matched_value;

Line 5688: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')

5684: SELECT
5685: translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5686: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
5687: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5688: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
5689: INTO
5690: x_party_search_rec.PARTY_NAME
5691: ,x_party_search_rec.PARTY_NUMBER
5692: ,x_party_search_rec.PARTY_TYPE

Line 5694: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

5690: x_party_search_rec.PARTY_NAME
5691: ,x_party_search_rec.PARTY_NUMBER
5692: ,x_party_search_rec.PARTY_TYPE
5693: ,x_party_search_rec.SIC_CODE
5694: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5695: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5696: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5697: AND HZ_PARTIES.party_id = p_party_id;
5698: ELSIF l_party_type = 'PERSON' THEN

Line 5695: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

5691: ,x_party_search_rec.PARTY_NUMBER
5692: ,x_party_search_rec.PARTY_TYPE
5693: ,x_party_search_rec.SIC_CODE
5694: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5695: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5696: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5697: AND HZ_PARTIES.party_id = p_party_id;
5698: ELSIF l_party_type = 'PERSON' THEN
5699: SELECT

Line 5696: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

5692: ,x_party_search_rec.PARTY_TYPE
5693: ,x_party_search_rec.SIC_CODE
5694: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5695: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5696: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5697: AND HZ_PARTIES.party_id = p_party_id;
5698: ELSIF l_party_type = 'PERSON' THEN
5699: SELECT
5700: translate(HZ_PARTIES.PARTY_NAME, '%',' ')