APPS.IGS_AD_IMP_008 dependencies on HZ_RELATIONSHIP_TYPES

Line 120: cp_subject_type hz_relationship_types.subject_type%TYPE,

116: --1. Validate the RELATIONSHIP_TYPE and RELATIONSHIP_CODE -- ssawhney PE CCR 2203778
117: -- OSS will not allow creation of relations between org and person through import process at this moment.
118:
119: CURSOR Relationship_Type_C(cp_lookup_type fnd_lookup_values.lookup_type%TYPE,
120: cp_subject_type hz_relationship_types.subject_type%TYPE,
121: cp_object_type hz_relationship_types.object_type%TYPE,
122: cp_appl_id fnd_lookup_values.view_application_id%TYPE,
123: cp_relationship_code P_Relations_Rec.Relationship_code%TYPE,
124: cp_relationship_type P_Relations_Rec.Relationship_type%TYPE,

Line 121: cp_object_type hz_relationship_types.object_type%TYPE,

117: -- OSS will not allow creation of relations between org and person through import process at this moment.
118:
119: CURSOR Relationship_Type_C(cp_lookup_type fnd_lookup_values.lookup_type%TYPE,
120: cp_subject_type hz_relationship_types.subject_type%TYPE,
121: cp_object_type hz_relationship_types.object_type%TYPE,
122: cp_appl_id fnd_lookup_values.view_application_id%TYPE,
123: cp_relationship_code P_Relations_Rec.Relationship_code%TYPE,
124: cp_relationship_type P_Relations_Rec.Relationship_type%TYPE,
125: cp_security_group_id fnd_lookup_values.security_group_id%TYPE) IS

Line 127: FROM FND_LOOKUP_VALUES lk, hz_relationship_types hz

123: cp_relationship_code P_Relations_Rec.Relationship_code%TYPE,
124: cp_relationship_type P_Relations_Rec.Relationship_type%TYPE,
125: cp_security_group_id fnd_lookup_values.security_group_id%TYPE) IS
126: SELECT COUNT(1)
127: FROM FND_LOOKUP_VALUES lk, hz_relationship_types hz
128: WHERE hz.forward_rel_code= cp_relationship_code AND
129: hz.relationship_type = cp_relationship_type AND
130: lk.LOOKUP_TYPE = cp_lookup_type AND
131: lk.lookup_code = hz.forward_rel_code AND