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 5683: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')

5679: SELECT
5680: translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5681: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
5682: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5683: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
5684: INTO
5685: x_party_search_rec.PARTY_NAME
5686: ,x_party_search_rec.PARTY_NUMBER
5687: ,x_party_search_rec.PARTY_TYPE

Line 5689: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

5685: x_party_search_rec.PARTY_NAME
5686: ,x_party_search_rec.PARTY_NUMBER
5687: ,x_party_search_rec.PARTY_TYPE
5688: ,x_party_search_rec.SIC_CODE
5689: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5690: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5691: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5692: AND HZ_PARTIES.party_id = p_party_id;
5693: ELSIF l_party_type = 'PERSON' THEN

Line 5690: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

5686: ,x_party_search_rec.PARTY_NUMBER
5687: ,x_party_search_rec.PARTY_TYPE
5688: ,x_party_search_rec.SIC_CODE
5689: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5690: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5691: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5692: AND HZ_PARTIES.party_id = p_party_id;
5693: ELSIF l_party_type = 'PERSON' THEN
5694: SELECT

Line 5691: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

5687: ,x_party_search_rec.PARTY_TYPE
5688: ,x_party_search_rec.SIC_CODE
5689: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5690: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5691: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5692: AND HZ_PARTIES.party_id = p_party_id;
5693: ELSIF l_party_type = 'PERSON' THEN
5694: SELECT
5695: translate(HZ_PARTIES.PARTY_NAME, '%',' ')