APPS.IGS_AD_IMP_025 dependencies on HZ_RELATIONSHIPS

Line 2000: HZ_RELATIONSHIPS R

1996: CURSOR chk_to_whom_code(cp_person_id privacy_cur_rec.person_id%TYPE,cp_to_whom_code privacy_cur_rec.to_whom_code%TYPE)
1997: IS
1998: SELECT 1
1999: FROM FND_LOOKUP_VALUES L,
2000: HZ_RELATIONSHIPS R
2001: WHERE L.LOOKUP_CODE = R.RELATIONSHIP_CODE AND
2002: L.LOOKUP_TYPE = 'PARTY_RELATIONS_TYPE' AND
2003: L.LANGUAGE = USERENV('LANG') AND
2004: L.VIEW_APPLICATION_ID = 222 AND

Line 2052: --3.) Validate TO_WHOM_CODE column in the interface table. Call igs_pe_pers_imp_001.validate_lookup_type_code. If not validated, check in HZ_RELATIONSHIPS.

2048: l_error_code := 'E353'; -- not a valid ACTION_CODE
2049: RAISE NO_DATA_FOUND;
2050: END IF;
2051:
2052: --3.) Validate TO_WHOM_CODE column in the interface table. Call igs_pe_pers_imp_001.validate_lookup_type_code. If not validated, check in HZ_RELATIONSHIPS.
2053:
2054: IF (NOT igs_pe_pers_imp_001.validate_lookup_type_code('PERSON_PRIVACY_RELEASE',p_priv_rec.to_whom_code,8405))
2055: THEN
2056: l_exists := null;