APPS.XLE_ASSOCIATIONS_INFO SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 126

	    select assoc.subject_id
	    BULK COLLECT
	    INTO p_assocs
	    from XLE_ASSOCIATIONS assoc, XLE_ASSOCIATION_TYPES assoc_types
	    where assoc.object_id = p_object_id
            and assoc_types.ASSOCIATION_TYPE_ID = assoc.ASSOCIATION_TYPE_ID
	    and assoc.association_type_id = x_association_type_id
	    and assoc.subject_parent_id = NVL(p_legal_entity_id,assoc.subject_parent_id)
            and assoc_types.context = p_context
	    and assoc_types.effective_to is null;

Line: 146

	    select assoc.object_id
	    BULK COLLECT
	    INTO p_assocs
	    from XLE_ASSOCIATIONS assoc, XLE_ASSOCIATION_TYPES assoc_types
	    where assoc.subject_id = p_subject_id
            and assoc_types.ASSOCIATION_TYPE_ID = assoc.ASSOCIATION_TYPE_ID
	    and assoc.association_type_id = x_association_type_id
	    and assoc.subject_parent_id = NVL(p_legal_entity_id,assoc.subject_parent_id)
            and assoc_types.context = p_context
	    and assoc_types.effective_to is null;