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

5839: IF l_party_type = 'ORGANIZATION' THEN
5840: SELECT
5841: translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
5842: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5843: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
5844: INTO
5845: x_party_search_rec.PARTY_NUMBER
5846: ,x_party_search_rec.PARTY_TYPE
5847: ,x_party_search_rec.SIC_CODE

Line 5848: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

5844: INTO
5845: x_party_search_rec.PARTY_NUMBER
5846: ,x_party_search_rec.PARTY_TYPE
5847: ,x_party_search_rec.SIC_CODE
5848: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5849: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5850: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5851: AND HZ_PARTIES.party_id = p_party_id;
5852: ELSIF l_party_type = 'PERSON' THEN

Line 5849: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

5845: x_party_search_rec.PARTY_NUMBER
5846: ,x_party_search_rec.PARTY_TYPE
5847: ,x_party_search_rec.SIC_CODE
5848: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5849: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5850: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5851: AND HZ_PARTIES.party_id = p_party_id;
5852: ELSIF l_party_type = 'PERSON' THEN
5853: SELECT

Line 5850: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

5846: ,x_party_search_rec.PARTY_TYPE
5847: ,x_party_search_rec.SIC_CODE
5848: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5849: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5850: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5851: AND HZ_PARTIES.party_id = p_party_id;
5852: ELSIF l_party_type = 'PERSON' THEN
5853: SELECT
5854: translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')