APPS.HZ_MATCH_RULE_238 dependencies on HZ_PARTY_SITES

Line 372: FROM HZ_PARTY_SITES, HZ_LOCATIONS

368: IF p_attribute = 'POSTAL_CODE' THEN
369: BEGIN
370: SELECT HZ_LOCATIONS.POSTAL_CODE
371: INTO l_matched_value
372: FROM HZ_PARTY_SITES, HZ_LOCATIONS
373: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
374: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
375: EXCEPTION
376: WHEN NO_DATA_FOUND THEN

Line 373: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

369: BEGIN
370: SELECT HZ_LOCATIONS.POSTAL_CODE
371: INTO l_matched_value
372: FROM HZ_PARTY_SITES, HZ_LOCATIONS
373: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
374: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
375: EXCEPTION
376: WHEN NO_DATA_FOUND THEN
377: l_matched_value := 'Err';

Line 374: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

370: SELECT HZ_LOCATIONS.POSTAL_CODE
371: INTO l_matched_value
372: FROM HZ_PARTY_SITES, HZ_LOCATIONS
373: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
374: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
375: EXCEPTION
376: WHEN NO_DATA_FOUND THEN
377: l_matched_value := 'Err';
378: END;

Line 4175: where owner_table_name = 'HZ_PARTY_SITES'

4171: p_contact_ids HZ_PARTY_SEARCH.IDList;
4172: l_match_idx NUMBER;
4173: cursor get_cpts_for_party_sites is select contact_point_id
4174: from hz_contact_points
4175: where owner_table_name = 'HZ_PARTY_SITES'
4176: and primary_flag='Y'
4177: and owner_table_id = p_party_site_id;
4178: BEGIN
4179: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5527: FROM HZ_PARTY_SITES

5523: l_party_id := p_party_id;
5524: FOR PARTY_SITES IN (
5525: SELECT party_site_id FROM (
5526: SELECT party_site_id,identifying_address_flag
5527: FROM HZ_PARTY_SITES
5528: WHERE party_id = p_party_id
5529: AND (status is null OR status = 'A')
5530: AND identifying_address_flag='Y'
5531: UNION

Line 5534: FROM HZ_PARTY_SITES

5530: AND identifying_address_flag='Y'
5531: UNION
5532:
5533: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5534: FROM HZ_PARTY_SITES
5535: WHERE party_id = p_party_id
5536: AND (status is null OR status = 'A')
5537: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
5538: AND ROWNUM<6

Line 5542: FROM HZ_PARTY_SITES

5538: AND ROWNUM<6
5539: UNION
5540:
5541: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5542: FROM HZ_PARTY_SITES
5543: WHERE (status is null OR status = 'A')
5544: AND party_id in (
5545: SELECT party_id
5546: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 5582: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5578: AND ROWNUM<6
5579: UNION
5580:
5581: SELECT CONTACT_POINT_ID
5582: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5583: WHERE PRIMARY_FLAG = 'Y'
5584: AND owner_table_name = 'HZ_PARTY_SITES'
5585: AND owner_table_id = party_site_id
5586: AND PARTY_ID = p_party_id

Line 5584: AND owner_table_name = 'HZ_PARTY_SITES'

5580:
5581: SELECT CONTACT_POINT_ID
5582: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5583: WHERE PRIMARY_FLAG = 'Y'
5584: AND owner_table_name = 'HZ_PARTY_SITES'
5585: AND owner_table_id = party_site_id
5586: AND PARTY_ID = p_party_id
5587: AND IDENTIFYING_ADDRESS_FLAG = 'Y') LOOP
5588: l_contact_pt_ids(cpt) := CONTACT_POINTS.CONTACT_POINT_ID;

Line 5727: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5723: ) IS
5724: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5725: SELECT party_site_id
5726: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5727: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5728: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5729: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5730:
5731: I NUMBER;

Line 5728: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

5724: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5725: SELECT party_site_id
5726: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5727: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5728: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5729: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5730:
5731: I NUMBER;
5732: J NUMBER:=1;

Line 5729: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;

5725: SELECT party_site_id
5726: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5727: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5728: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5729: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5730:
5731: I NUMBER;
5732: J NUMBER:=1;
5733: l_party_site_id NUMBER;