APPS.HZ_PARTY_MERGE dependencies on HZ_LOCATIONS

Line 3575: -- Handle DNB data in HZ_PARTY_SITES/HZ_LOCATIONS

3571:
3572:
3573:
3574: -- *******************************************
3575: -- Handle DNB data in HZ_PARTY_SITES/HZ_LOCATIONS
3576:
3577: -- Keep to's data.
3578: -- Inactivate the from's active party site.
3579: IF case2 OR (case3 and l_to_is_branch<>'Y') THEN

Line 3630: FROM HZ_PARTY_SITES ps,HZ_LOCATIONS l

3626: -- Do the exact comparison betn the from_dnb_ps and to_dnb ps.
3627: -- If exactly same: merge to into from
3628: BEGIN
3629: Select 'True' into case_new
3630: FROM HZ_PARTY_SITES ps,HZ_LOCATIONS l
3631: WHERE ps.party_site_id = FROM_PS.party_site_id
3632: AND ps.location_id = FROM_PS.location_id
3633: AND l.location_id = ps.location_id
3634: AND (ps.status IS NULL OR ps.status = 'A')

Line 3655: FROM HZ_LOCATIONS

3651: TRIM(CITY) ||
3652: TRIM(PROVINCE) ||
3653: TRIM(COUNTY) ||
3654: TRIM(POSTAL_CODE))
3655: FROM HZ_LOCATIONS
3656: WHERE LOCATION_ID = l_to_loc_id) AND rownum =1;
3657: EXCEPTION
3658: WHEN No_Data_Found THEN
3659: NULL;

Line 3732: FROM HZ_PARTY_SITES ps1,HZ_LOCATIONS l

3728: FROM HZ_PARTY_SITES ps
3729: WHERE actual_content_source = 'DNB'
3730: AND ps.party_id = x_to_id
3731: AND (ps.location_id = FROM_PS.location_id OR ('Y' = (Select 'Y'
3732: FROM HZ_PARTY_SITES ps1,HZ_LOCATIONS l
3733: WHERE ps1.party_site_id = FROM_PS.party_site_id
3734: AND ps1.location_id = FROM_PS.location_id
3735: AND l.location_id = ps1.location_id
3736: --AND (ps1.status IS NULL OR ps1.status = 'A')

Line 3757: FROM HZ_LOCATIONS

3753: TRIM(CITY) ||
3754: TRIM(PROVINCE) ||
3755: TRIM(COUNTY) ||
3756: TRIM(POSTAL_CODE))
3757: FROM HZ_LOCATIONS
3758: WHERE LOCATION_ID = ps.location_id) AND rownum =1))) AND rownum =1 ;
3759:
3760: EXCEPTION
3761: WHEN No_Data_Found THEN