APPS.FUN_SECURITY dependencies on HZ_RELATIONSHIPS

Line 99: from hz_relationships where subject_id = -999

95: AND HUA.PARTY_ID=HZP.PARTY_ID
96: AND HUA.PARTY_USAGE_CODE ='INTERCOMPANY_ORG'
97: AND XFI.TRANSACTING_ENTITY_FLAG = 'Y') QRSLT
98: WHERE (PARTYID not in ( select object_id
99: from hz_relationships where subject_id = -999
100: and subject_table_name like 'HZ_PARTIES'
101: and relationship_code like 'CONTACT_OF'
102: and Directional_flag = 'F'
103: and start_date < sysdate and end_date > sysdate ));

Line 179: l_object_version_number hz_relationships.object_version_number%TYPE;

175: -- Relationship updation in update_assign done in the JAVA code.
176:
177: DECLARE
178: l_relationship_id NUMBER(15);
179: l_object_version_number hz_relationships.object_version_number%TYPE;
180: l_party_object_version_number hz_relationships.object_version_number%TYPE := NULL;
181: l_cont_object_version_number hz_relationships.object_version_number%TYPE;
182: l_rel_object_version_number hz_relationships.object_version_number%TYPE;
183: l_tca_relationship_record HZ_RELATIONSHIP_V2PUB.relationship_rec_type;

Line 180: l_party_object_version_number hz_relationships.object_version_number%TYPE := NULL;

176:
177: DECLARE
178: l_relationship_id NUMBER(15);
179: l_object_version_number hz_relationships.object_version_number%TYPE;
180: l_party_object_version_number hz_relationships.object_version_number%TYPE := NULL;
181: l_cont_object_version_number hz_relationships.object_version_number%TYPE;
182: l_rel_object_version_number hz_relationships.object_version_number%TYPE;
183: l_tca_relationship_record HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
184: l_tca_contact_role_record HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_ROLE_REC_TYPE;

Line 181: l_cont_object_version_number hz_relationships.object_version_number%TYPE;

177: DECLARE
178: l_relationship_id NUMBER(15);
179: l_object_version_number hz_relationships.object_version_number%TYPE;
180: l_party_object_version_number hz_relationships.object_version_number%TYPE := NULL;
181: l_cont_object_version_number hz_relationships.object_version_number%TYPE;
182: l_rel_object_version_number hz_relationships.object_version_number%TYPE;
183: l_tca_relationship_record HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
184: l_tca_contact_role_record HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_ROLE_REC_TYPE;
185: l_tca_contact_record HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE;

Line 182: l_rel_object_version_number hz_relationships.object_version_number%TYPE;

178: l_relationship_id NUMBER(15);
179: l_object_version_number hz_relationships.object_version_number%TYPE;
180: l_party_object_version_number hz_relationships.object_version_number%TYPE := NULL;
181: l_cont_object_version_number hz_relationships.object_version_number%TYPE;
182: l_rel_object_version_number hz_relationships.object_version_number%TYPE;
183: l_tca_relationship_record HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
184: l_tca_contact_role_record HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_ROLE_REC_TYPE;
185: l_tca_contact_record HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE;
186: l_org_contact_role_id NUMBER;

Line 195: FROM hz_relationships hzr

191: CURSOR get_relationship_id_c(p_cursor_personid NUMBER,
192: p_cursor_orgid NUMBER)
193: IS
194: SELECT relationship_id
195: FROM hz_relationships hzr
196: WHERE hzr.subject_id=p_cursor_personid
197: AND hzr.object_id=p_cursor_orgid
198: AND hzr.relationship_code='CONTACT_OF'
199: AND hzr.relationship_type='CONTACT'

Line 206: FROM hz_relationships

202:
203: CURSOR get_object_version_num_c (p_rel_id NUMBER)
204: IS
205: SELECT object_version_number
206: FROM hz_relationships
207: WHERE relationship_id=p_rel_id ;
208:
209: BEGIN
210:

Line 262: FROM hz_relationships hzr, hz_org_contacts hc, hz_org_contact_roles hcr

258: END IF;
259:
260: SELECT hcr.org_contact_role_id, hcr.org_contact_id, hcr.primary_flag, hcr.status
261: INTO l_org_contact_role_id, l_org_contact_id, l_primary_flag, l_status
262: FROM hz_relationships hzr, hz_org_contacts hc, hz_org_contact_roles hcr
263: WHERE hzr.subject_id=p_person_id
264: AND hzr.object_id=v_org_record.partyid
265: AND hzr.relationship_code='CONTACT_OF'
266: AND hzr.relationship_type='CONTACT'