APPS.HZ_MATCH_RULE_35 dependencies on HZ_ORGANIZATION_PROFILES

Line 404: FROM HZ_ORGANIZATION_PROFILES

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

Line 410: FROM HZ_ORGANIZATION_PROFILES

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

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

5834: IF l_party_type = 'ORGANIZATION' THEN
5835: SELECT
5836: translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
5837: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5838: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
5839: INTO
5840: x_party_search_rec.PARTY_NUMBER
5841: ,x_party_search_rec.PARTY_TYPE
5842: ,x_party_search_rec.SIC_CODE

Line 5843: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

5839: INTO
5840: x_party_search_rec.PARTY_NUMBER
5841: ,x_party_search_rec.PARTY_TYPE
5842: ,x_party_search_rec.SIC_CODE
5843: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5844: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5845: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5846: AND HZ_PARTIES.party_id = p_party_id;
5847: ELSIF l_party_type = 'PERSON' THEN

Line 5844: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

5840: x_party_search_rec.PARTY_NUMBER
5841: ,x_party_search_rec.PARTY_TYPE
5842: ,x_party_search_rec.SIC_CODE
5843: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5844: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5845: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5846: AND HZ_PARTIES.party_id = p_party_id;
5847: ELSIF l_party_type = 'PERSON' THEN
5848: SELECT

Line 5845: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

5841: ,x_party_search_rec.PARTY_TYPE
5842: ,x_party_search_rec.SIC_CODE
5843: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5844: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5845: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5846: AND HZ_PARTIES.party_id = p_party_id;
5847: ELSIF l_party_type = 'PERSON' THEN
5848: SELECT
5849: translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')