DBA Data[Home] [Help]

APPS.XLE_ASSOCIATIONS_INFO dependencies on XLE_ASSOCIATION_TYPES

Line 62: p_context IN XLE_ASSOCIATION_TYPES.Context%TYPE,

58: x_msg_data OUT NOCOPY VARCHAR2,
59:
60:
61: -- ***** Legal Association information parameters *****
62: p_context IN XLE_ASSOCIATION_TYPES.Context%TYPE,
63: p_object_type IN XLE_ASSOC_OBJECT_TYPES.Name%TYPE,
64: p_subject_type IN XLE_ASSOC_OBJECT_TYPES.Name%TYPE,
65: p_legal_entity_id IN XLE_ASSOCIATIONS.SUBJECT_PARENT_ID%TYPE,
66: p_object_id IN XLE_ASSOCIATIONS.Object_Id%TYPE,

Line 129: from XLE_ASSOCIATIONS assoc, XLE_ASSOCIATION_TYPES assoc_types

125:
126: select assoc.subject_id
127: BULK COLLECT
128: INTO p_assocs
129: from XLE_ASSOCIATIONS assoc, XLE_ASSOCIATION_TYPES assoc_types
130: where assoc.object_id = p_object_id
131: and assoc_types.ASSOCIATION_TYPE_ID = assoc.ASSOCIATION_TYPE_ID
132: and assoc.association_type_id = x_association_type_id
133: and assoc.subject_parent_id = NVL(p_legal_entity_id,assoc.subject_parent_id)

Line 149: from XLE_ASSOCIATIONS assoc, XLE_ASSOCIATION_TYPES assoc_types

145:
146: select assoc.object_id
147: BULK COLLECT
148: INTO p_assocs
149: from XLE_ASSOCIATIONS assoc, XLE_ASSOCIATION_TYPES assoc_types
150: where assoc.subject_id = p_subject_id
151: and assoc_types.ASSOCIATION_TYPE_ID = assoc.ASSOCIATION_TYPE_ID
152: and assoc.association_type_id = x_association_type_id
153: and assoc.subject_parent_id = NVL(p_legal_entity_id,assoc.subject_parent_id)