APPS.HZ_MATCH_RULE_41 dependencies on HZ_PARTY_SITES

Line 376: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

Line 377: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

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

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

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

Line 4188: where owner_table_name = 'HZ_PARTY_SITES'

4184: p_contact_ids HZ_PARTY_SEARCH.IDList;
4185: l_match_idx NUMBER;
4186: cursor get_cpts_for_party_sites is select contact_point_id
4187: from hz_contact_points
4188: where owner_table_name = 'HZ_PARTY_SITES'
4189: and primary_flag='Y'
4190: and owner_table_id = p_party_site_id;
4191: BEGIN
4192: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5575: FROM HZ_PARTY_SITES

5571: l_party_id := p_party_id;
5572: FOR PARTY_SITES IN (
5573: SELECT party_site_id FROM (
5574: SELECT party_site_id,identifying_address_flag
5575: FROM HZ_PARTY_SITES
5576: WHERE party_id = p_party_id
5577: AND (status is null OR status = 'A')
5578: AND identifying_address_flag='Y'
5579: UNION

Line 5582: FROM HZ_PARTY_SITES

5578: AND identifying_address_flag='Y'
5579: UNION
5580:
5581: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5582: FROM HZ_PARTY_SITES
5583: WHERE party_id = p_party_id
5584: AND (status is null OR status = 'A')
5585: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
5586: AND ROWNUM<6

Line 5590: FROM HZ_PARTY_SITES

5586: AND ROWNUM<6
5587: UNION
5588:
5589: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5590: FROM HZ_PARTY_SITES
5591: WHERE (status is null OR status = 'A')
5592: AND party_id in (
5593: SELECT party_id
5594: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 5630: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5626: AND ROWNUM<6
5627: UNION
5628:
5629: SELECT CONTACT_POINT_ID
5630: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5631: WHERE PRIMARY_FLAG = 'Y'
5632: AND owner_table_name = 'HZ_PARTY_SITES'
5633: AND owner_table_id = party_site_id
5634: AND PARTY_ID = p_party_id

Line 5632: AND owner_table_name = 'HZ_PARTY_SITES'

5628:
5629: SELECT CONTACT_POINT_ID
5630: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5631: WHERE PRIMARY_FLAG = 'Y'
5632: AND owner_table_name = 'HZ_PARTY_SITES'
5633: AND owner_table_id = party_site_id
5634: AND PARTY_ID = p_party_id
5635: AND IDENTIFYING_ADDRESS_FLAG = 'Y') LOOP
5636: l_contact_pt_ids(cpt) := CONTACT_POINTS.CONTACT_POINT_ID;

Line 5773: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5769: ) IS
5770: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5771: SELECT party_site_id
5772: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5773: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5774: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5775: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5776:
5777: I NUMBER;

Line 5774: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

5770: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5771: SELECT party_site_id
5772: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5773: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5774: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5775: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5776:
5777: I NUMBER;
5778: J NUMBER:=1;

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

5771: SELECT party_site_id
5772: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5773: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5774: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5775: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5776:
5777: I NUMBER;
5778: J NUMBER:=1;
5779: l_party_site_id NUMBER;