APPS.HZ_MERGE_DUP_CHECK dependencies on HZ_PARTY_SITES

Line 1056: FROM HZ_PARTY_SITES

1052:
1053: CURSOR dupcheck IS
1054: SELECT
1055: PARTY_SITE_ID
1056: FROM HZ_PARTY_SITES
1057: WHERE party_id = p_to_fk_id
1058: AND (status IS NULL OR status = 'A')
1059: AND LOCATION_ID = (
1060: SELECT LOCATION_ID

Line 1061: FROM HZ_PARTY_SITES

1057: WHERE party_id = p_to_fk_id
1058: AND (status IS NULL OR status = 'A')
1059: AND LOCATION_ID = (
1060: SELECT LOCATION_ID
1061: FROM HZ_PARTY_SITES
1062: WHERE party_site_id = p_from_id);
1063:
1064: l_record_id NUMBER;
1065: BEGIN

Line 1317: FROM HZ_PARTY_SITES ps,

1313: RETURN VARCHAR2 IS
1314:
1315: CURSOR dupcheck IS
1316: SELECT PARTY_SITE_ID
1317: FROM HZ_PARTY_SITES ps,
1318: HZ_LOCATIONS l
1319: WHERE ps.party_id = p_to_fk_id
1320: AND ps.location_id = l.location_id
1321: AND (ps.status IS NULL OR ps.status = 'A')