APPS.XLE_CONTACT_GRP dependencies on XLE_CONTACT_LEGAL_ROLES

Line 12: xle_contact_legal_roles role

8:
9: CURSOR c_get_role IS
10: SELECT lkup.meaning role_meaning
11: FROM xle_lookups lkup,
12: xle_contact_legal_roles role
13: WHERE role.lookup_code = lkup.lookup_code
14: AND role.contact_party_id = p_contact_party_id
15: AND role.le_etb_party_id = p_le_etb_party_id
16: AND role.lookup_type = 'XLE_CONTACT_ROLE'

Line 70: UPDATE xle_contact_legal_roles

66: THEN
67: x_return_status := FND_API.G_RET_STS_ERROR;
68: x_msg_data := 'Mandatory parameters not passed to end_contact_roles';
69: ELSE
70: UPDATE xle_contact_legal_roles
71: SET effective_to = SYSDATE
72: WHERE contact_party_id = p_contact_party_id
73: AND le_etb_party_id = p_le_etb_party_id
74: AND effective_to IS NULL;