APPS.HZ_MERGE_DUP_CHECK dependencies on HZ_PARTY_SITE_USES

Line 1012: FROM HZ_PARTY_SITE_USES

1008:
1009: CURSOR dupcheck IS
1010: SELECT
1011: PARTY_SITE_USE_ID
1012: FROM HZ_PARTY_SITE_USES
1013: WHERE party_site_id = p_to_fk_id
1014: AND (status IS NULL OR status = 'A')
1015: AND SITE_USE_TYPE =
1016: (SELECT

Line 1018: FROM HZ_PARTY_SITE_USES

1014: AND (status IS NULL OR status = 'A')
1015: AND SITE_USE_TYPE =
1016: (SELECT
1017: SITE_USE_TYPE
1018: FROM HZ_PARTY_SITE_USES
1019: WHERE party_site_use_id = p_from_id);
1020:
1021: l_record_id NUMBER;
1022: BEGIN