APPS.HZ_MATCH_RULE_41 dependencies on HZ_ORGANIZATION_PROFILES

Line 334: FROM HZ_ORGANIZATION_PROFILES

330: FROM HZ_PARTIES
331: WHERE party_id = p_record_id;
332: IF l_party_type = 'ORGANIZATION' THEN
333: SELECT TAX_REFERENCE INTO l_matched_value
334: FROM HZ_ORGANIZATION_PROFILES
335: WHERE party_id = p_record_id
336: and effective_end_date is null
337: and rownum = 1;
338: ELSIF l_party_type = 'PERSON' THEN

Line 5721: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')

5717: END IF;
5718: IF l_party_type = 'ORGANIZATION' THEN
5719: SELECT
5720: translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5721: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5722: INTO
5723: x_party_search_rec.PARTY_NAME
5724: ,x_party_search_rec.TAX_REFERENCE
5725: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

Line 5725: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

5721: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5722: INTO
5723: x_party_search_rec.PARTY_NAME
5724: ,x_party_search_rec.TAX_REFERENCE
5725: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5726: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5727: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5728: AND HZ_PARTIES.party_id = p_party_id;
5729: ELSIF l_party_type = 'PERSON' THEN

Line 5726: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

5722: INTO
5723: x_party_search_rec.PARTY_NAME
5724: ,x_party_search_rec.TAX_REFERENCE
5725: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5726: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5727: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5728: AND HZ_PARTIES.party_id = p_party_id;
5729: ELSIF l_party_type = 'PERSON' THEN
5730: SELECT

Line 5727: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

5723: x_party_search_rec.PARTY_NAME
5724: ,x_party_search_rec.TAX_REFERENCE
5725: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5726: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5727: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5728: AND HZ_PARTIES.party_id = p_party_id;
5729: ELSIF l_party_type = 'PERSON' THEN
5730: SELECT
5731: translate(HZ_PARTIES.PARTY_NAME, '%',' ')